ThinkServer

Exporting a MySQL database: Difference between revisions

← Older editNewer edit →
>Samthecrazyman
m Changed date format to be correct an work, spelling correction
>Samthecrazyman
m Removed escaping statement, not needed anymore
Line 51: Line 51:
** Make sure MySQL is running
** Make sure MySQL is running
** Make sure the user has the correct privileges
** Make sure the user has the correct privileges
* The % on the date part of the command must be escaped with a \ or the code will stop past the %. Cron interprets % as the end of the line and must be escaped to make it pass it.
* Passwords with any special characters may make cron fail as it uses some characters for commands. You may have to change your MySQL password to an alphanumeric only password.
* Passwords with any special characters may make cron fail as it uses some characters for commands. You may have to change your MySQL password to an alphanumeric only password.
* KDE task scheduler has a problem at the time of writing that when you edit a job, the user randomly changes. Make sure that when you edit a job, you change the user back to root or the job will more than likely fail.
* KDE task scheduler has a problem at the time of writing that when you edit a job, the user randomly changes. Make sure that when you edit a job, you change the user back to root or the job will more than likely fail.
Retrieved from "https://thinkserver.freddythechick.net/wiki/Exporting_a_MySQL_database"