Faire Une Copie Rapide Des Forums

[thewiseoldman]

Une commande méconnue pour ceux qui n'utilisent pas SQL, c'est la commande

INSERT INTO nom_table select * from nom_table2;

Cela permet très rapidement, bien plus vite qu'un export puis un import, de faire une copie de vos données.

 

Au préalable les tables réceptrices doivent exister. Avec la requête SQL de création des tables que vous trouverez dans le répertoire 'schematic/tables.sql' du package français ca ne devrait pas vous poser de problème.

 

Pour info voici à quoi cela ressemble pour la table admin_logs :

CREATE TABLE ibf_admin_logs (
 id bigint(20) NOT NULL auto_increment,
 act varchar(255) default NULL,
 code varchar(255) default NULL,
 member_id int(10) default NULL,
 ctime int(10) default NULL,
 note text,
 ip_address varchar(255) default NULL,
 PRIMARY KEY  (id)
);

 

Donc avec les quelques lignes ci-dessous j'effectue une copie de mes forums:

 

INSERT INTO ibf_admin_logs select * from ibfs_admin_logs;
INSERT INTO ibf_admin_sessions select * from ibfs_admin_sessions;
INSERT INTO ibf_attachments select * from ibfs_attachments;
INSERT INTO ibf_badwords select * from ibfs_badwords;
INSERT INTO ibf_calendar_events select * from ibfs_calendar_events;
INSERT INTO ibf_categories select * from ibfs_categories;
INSERT INTO ibf_contacts select * from ibfs_contacts;
INSERT INTO ibf_css select * from ibfs_css;
INSERT INTO ibf_emoticons select * from ibfs_emoticons;
INSERT INTO ibf_faq select * from ibfs_faq;
INSERT INTO ibf_forum_tracker select * from ibfs_forum_tracker;
INSERT INTO ibf_forums select * from ibfs_forums;
INSERT INTO ibf_groups select * from ibfs_groups;
INSERT INTO ibf_languages select * from ibfs_languages;
INSERT INTO ibf_macro select * from ibfs_macro;
INSERT INTO ibf_macro_name select * from ibfs_macro_name;
INSERT INTO ibf_member_extra select * from ibfs_member_extra;
INSERT INTO ibf_members select * from ibfs_members;
INSERT INTO ibf_messages select * from ibfs_messages;
INSERT INTO ibf_moderator_logs select * from ibfs_moderator_logs;
INSERT INTO ibf_moderators select * from ibfs_moderators;
INSERT INTO ibf_pfields_content select * from ibfs_pfields_content;
INSERT INTO ibf_pfields_data select * from ibfs_pfields_data;
INSERT INTO ibf_polls select * from ibfs_polls;
INSERT INTO ibf_posts select * from ibfs_posts;
INSERT INTO ibf_reg_antispam select * from ibfs_reg_antispam;
INSERT INTO ibf_rules select * from ibfs_rules;
INSERT INTO ibf_search_results select * from ibfs_search_results;
INSERT INTO ibf_sessions select * from ibfs_sessions;
INSERT INTO ibf_skin_templates select * from ibfs_skin_templates;
INSERT INTO ibf_skins select * from ibfs_skins;
INSERT INTO ibf_stats select * from ibfs_stats;
INSERT INTO ibf_templates select * from ibfs_templates;
INSERT INTO ibf_titles select * from ibfs_titles;
INSERT INTO ibf_tmpl_names select * from ibfs_tmpl_names;
INSERT INTO ibf_topics select * from ibfs_topics;
INSERT INTO ibf_tracker select * from ibfs_tracker;
INSERT INTO ibf_voters select * from ibfs_voters;

 

Pour passer sur les nouvelles tables il suffit d'éditer conf_global.php pour indiquer le nouveau préfixe de tables, ici ibf_.

 

$INFO['sql_tbl_prefix']  = 'ibf_';

 

Attention avant d'exécuter cette commande à nouveau il faudra vider les tables réceptrices soit via phpmyadmin soit via une requête SQL comme ceci:

DELETE FROM ibf_admin_logs;
DELETE FROM ibf_admin_sessions;
DELETE FROM ibf_attachments;
DELETE FROM ibf_badwords;
DELETE FROM ibf_calendar_events;
DELETE FROM ibf_categories;
DELETE FROM ibf_contacts;
DELETE FROM ibf_css;
DELETE FROM ibf_emoticons;
DELETE FROM ibf_faq;
DELETE FROM ibf_forum_tracker;
DELETE FROM ibf_forums;
DELETE FROM ibf_groups;
DELETE FROM ibf_languages;
DELETE FROM ibf_macro;
DELETE FROM ibf_macro_name;
DELETE FROM ibf_member_extra;
DELETE FROM ibf_members;
DELETE FROM ibf_messages;
DELETE FROM ibf_moderator_logs;
DELETE FROM ibf_moderators;
DELETE FROM ibf_pfields_content;
DELETE FROM ibf_pfields_data;
DELETE FROM ibf_polls;
DELETE FROM ibf_posts;
DELETE FROM ibf_reg_antispam;
DELETE FROM ibf_rules;
DELETE FROM ibf_search_results;
DELETE FROM ibf_sessions;
DELETE FROM ibf_skin_templates;
DELETE FROM ibf_skins;
DELETE FROM ibf_stats;
DELETE FROM ibf_templates;
DELETE FROM ibf_titles;
DELETE FROM ibf_tmpl_names;
DELETE FROM ibf_topics;
DELETE FROM ibf_tracker;
DELETE FROM ibf_voters;