jana Posted September 27, 2006 Share Posted September 27, 2006 I am new to mysql. can anyone tell me how to make backup database without using gui tools. Link to comment https://forums.phpfreaks.com/topic/22230-how-to-make-backup-for-a-particular-database/ Share on other sites More sharing options...
jvrothjr Posted September 27, 2006 Share Posted September 27, 2006 you could do many different things.1) stop the mysql server and copy the data folder 2) mysqldump to create a sql file backup3) use a tool like phpmyadmin to create sql dump files I use two of these nightly 1) on a site that is only used during bussness hours I use option [1] stop the server and copy folder.2) on the other site used 24/7 factory support I use mysqldump (via a schedule) to auto backup the database to sql file. Link to comment https://forums.phpfreaks.com/topic/22230-how-to-make-backup-for-a-particular-database/#findComment-99582 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.