When I try to create a .sql file from an external script (such as php), the resulting .sql file looks clean, but it causes problems with the application when imported.
When I use phpMyAdmin to create a similar .sql file by using Export, the generated .sql file is imported without causing any problems in my application.
The application is moodle 2.2, MySQL The version is 5.5, and the version of phpMyAdmin is 3.4.10.
Is it possible to use phpMyAdmin to automatically export a single database?
When I try to create a .sql file from an external script (such as php), the resulting .sql file looks clean, but it causes problems with the application when imported.
When I use phpMyAdmin to create a similar .sql file by using Export, the generated .sql file is imported without causing any problems in my application.
The application is moodle 2.2, MySQL The version is 5.5, and the phpMyAdmin version is 3.4.10.
The best option is to create a script, use mysqldump to execute the database export, and then execute the cronjob of the script .