How to backup/restore MySQL database without a plain dump?
Question by jumpingrightin: How to backup/restore MySQL database with out a plain dump?
How do you backup and restore a MySQL database on a Linux program without having employing the plain dump?
“Just copy the whole information folder of MySQL”
What is the Linux path to this?
Ideal answer:
Solution by Broken M
you could install phpMyAdmin to back it up…or you could do a plain dump…or use any of the backup features on the server…or use any of the multiple backup capabilities that come with mysql.
What do you feel? Answer below!
Related posts:
- How do I backup my mysql database?
- How Can I Automatically Backup My MySQL Database Hourly?
- How to take a database backup for mysql in linux environment?
- Q&A: MySQL – How to create a secure backup database file?
- How Can I Automatically Backup My MySQL Database?
Tagged with: Backup/Restore • Database • dump • MySQL • plain • without
Filed under: Linux Backup
Like this post? Subscribe to my RSS feed and get loads more!
Just copy the whole data folder of MySQL
“Just copy the whole data folder of MySQL”
best answer.
this is how i did mine.
open /etc/my.cnf
(this contains the mysql server configuration. we need to find where mysql put its files. since i use innodb, i found the data here:
innodb_data_home_dir = /var/lib/mysql/
and backup /etc/my.conf too. if you use a different my.cnf on a restored mysql server, it could destroy all the data there.
)
then you backup at least the following
ib* (includes ibdata1, ib_logfile1, ib_logfile2) which contains your entire database.)
all the folders found inside. it contains your tables and structures.
you dont have to backup the binlogs or SERVERNAME-bin.001. It contains the binary logs for replication.