Automation – How to automatically export the mysql database using phpMyAdmin

Can I 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 version of phpMyAdmin 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.

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 .

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 2270 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.