MySQL import and export the entire database as a file

MySQL import and export the entire database as a file When using, be sure to note whether it is in the import state, if it is an import operation, you must first back up the database, otherwise the data will be emptied. /* Export SELECT * into OUTFILE ' c:/name.txt ' Fields TERMINATED by ', ' optionally enclosed by ' \ ' LINES TERMINATED by ' \ n ' from zones; Import LOAD DATA INFILE ' c:/name.txt ' into TABLE zones Fields TERMINATED by ', ' optionally enclosed by ' \ ' LINES TERMINATED by ' \ n '; */ Set_time_limit (0); Define (HOST, ' 127.0.0.1 '); Define (USER, ' root '); Define (PWD, "); Define (DBNAME, ' test '); Define (DIR, ' e:/www/mysql_data/'); 0 for import 1 for export 2 for repair Define (operation,1); Mysql_connect (HOST,USER,PWD) or Die ("Could Not connect:". Mysql_error ()); mysql_select_db (DBNAME) or Die ("Could not select DB:". Mysql_error ()); $result = mysql_query ("Show Tables"); if (!is_dir (dir)) { Die (' Folder does not exist '); } if (operation==0) { Prerequisite: You need to import the table structure previously Export command: Mysqldump-u root-p-D test>test.sql while ($row = Mysql_fetch_array ($result, mysql_num)) { $fileName =dir. $row [0]. ". TXT "; if (file_exists ($fileName)) { Delete truncate $QUERYSQL = ' TRUNCATE TABLE '. $row [0]. ' `'; mysql_query ($QUERYSQL) or Die ("Could not truncate TABLE:". $querySql. Mysql_error ()); $QUERYSQL = "LOAD DATA INFILE '". $fileName. "' Into TABLE ' ". $row [0]." ` Fields TERMINATED by ', ' optionally enclosed by ' \ ' LINES TERMINATED by ' \ n ' "; mysql_query ($QUERYSQL) or Die (' Could not insert into table: '. $querySql. Mysql_error ()); echo ' insert into table '. $row [0]. ' Success. '; }else{ Echo ' not insert into table '. $row [0]. ' '; } } echo "The task is finished"; }else if (operation==1) { if (is_writable (DIR)) { while ($row = Mysql_fetch_array ($result, mysql_num)) { $fileName =dir. $row [0]. ". TXT "; if (file_exists ($fileName)) { Unlink ($fileName); } $QUERYSQL = "SELECT * into OUTFILE '". $fileName. "' Fields TERMINATED by ', ' optionally enclosed by ' \ ' LINES TERMINATED by ' \ n ' From '. $row [0]. " `"; mysql_query ($QUERYSQL) or Die ("Could not dump Table:".) $querySql. Mysql_error ()); echo ' Dump table '. $row [0]. ' Success. '; } echo "The task is finished"; }else{ Echo ' Folder '. DIR. ' Can not writeable '; } }else if (operation==2) { while ($row = Mysql_fetch_array ($result, mysql_num)) { $fileName =dir. $row [0]. ". TXT "; if (file_exists ($fileName)) { Unlink ($fileName); } $QUERYSQL = "REPAIR TABLE ' $row [0] '"; mysql_query ($QUERYSQL) or Die ("Could not repair table:". $querySql. Mysql_error ()); echo ' Repair table '. $row [0]. ' Success. '; } } Mysql_free_result ($result); Mysql_close (); ?> Copy Code

