I was asked to create an export and import mysql database with it's structure and data into a .sql file using php scripting and not phpmyadmin to make the user be able to backup his data?
Does anybody have an idea how to do that??
Thanks in advance
2
-
Does it have to be just PHP? Could always use mysqldump, and if it needed to be a PHP script, could use mysqldump through exec.Corbin– Corbin2012-04-04 22:17:14 +00:00Commented Apr 4, 2012 at 22:17
-
1Dup of Easy way to export a SQL table without access to the server or phpMyADMIN, php code to mysql database export, Best practice: Import mySQL file in PHP; split queries, and likely many others.outis– outis2012-04-04 22:22:01 +00:00Commented Apr 4, 2012 at 22:22
Add a comment
|
3 Answers
SAFE and WORKING SOLUTION :
EXPORT_TABLES("localhost","user","pass","db_name");
// has 5th and 6th optional parameters too.
Latest version is available at github: Export.php + Import.php
3 Comments
Milad Ghiravani
Thank you! this is a best code. because other codes work with "exec" or "system" functions.this functions disabled on Linux hosts. but this script worked on Linux hosts.
Karthi
fantastic and its very useful one.
http://www.php-mysql-tutorial.com/wikis/mysql-tutorials/using-php-to-backup-mysql-databases.aspx
either
$tableName = 'mypet';
$backupFile = 'backup/mypet.sql';
$query = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName";
$result = mysql_query($query);
or
$backupFile = $dbname . date("Y-m-d-H-i-s") . '.gz';
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";
system($command);
2 Comments
Mohamed Hassan
anybody knows how to import it to phpmyadmin through a php script
binarious
Look at the tutorial. There is a
"LOAD DATA INFILE 'backupFile' INTO TABLE $tableName";section.Here is a nice class that worked just fine for me. if it says fopen access denied, try to change the folder permissions.
