haii.. i have a lot of database on my note book, but same like my computer has a problem and i need to format it... but my problem is i don't know how to backup my database... if i copy and paste the folder of database... it can't function after that... all my data will be lost... so, how i can backup my database, or what i should do to solve this problem...? please help.... thanks..
mysqldump (http:// dev.mysql.com/doc/refman/5.0/en/mysqldump.html) ? This tool is designed exactly for backuping and transffering databases. Also, on some systems and server setttings, it is possible to just copy the 'mysql' folder into the new system and everything will still work. I've done this sooo many times on an old slackware 10.2, mysql 4.0.20 and never lost any data. But that depends on mysql and database configurations, so there is a risk of data loss
mysqldump is a simple option, you could install phpmyadmin if you need a pretty web interface, if not, just mysqldum -u username -ppassword database_name > backup.sql
mysqldump --opt -u root -p yourdatabasename > /var/www/desired-sqldump.sql Replace the "yourdatabasename" with your own, and run this command. A mysql dump called "desired-sqldump.sql" will be created in /var/www If you want to put the dump back after you format, you do this mysql yourdatabasename < desired-sqldump.sql