u mysqlusername -p databasename (tablename tablename tablename) | bzip2Įnter password: (enter your mysql Example: Use mysqldump (man mysqldump is available): mysqldump -add-drop-table -h mysqlhostserver Change your directory to the directory you want to dump things to: cd files/blogĢ. In that case straight mysql code will help.ġ. Please note that this method is untested. Then you have to use the command line tools that comes with Mysql. PhpMyAdmin has some file size limits so if you have large databases it may no be possible to backup using phpMyAdmin. On the "SQL"-page, unclick the show query here again.ģ. To restore a database, you click the SQL tab.Ģ. Then click "GO" to download the backup file.ġ. Check "Save as file", do not change the file name, use compression if you want. Check "DATA", check use "hexadecimal for binary field". Select"SQL"-> for output format, Check "Structure" and "Add AUTO_INCREMENT" value. There should be as many tables in the export list as showing under the database name. Make sure that you have selected to export your entire database, and not just one table. Click Export in the Menu to get to where you can backup you MySql database. It is assumed that you have phpMyAdmin installed since a lot of web service providers use it.ġ. It is easy and fast, so there is no reason for not doing it. Backing it up once every month or so makes sure you never loose too much of your work in case of a server crash, and it will make you sleep better at night. If you have spent a lot of time making the content and it is only stored in the Mysql server, you will feel very bad if it gets lost for ever. A lot of web service providers say they do backup of all the files, but you should never blindly trust them. All the content in the MySql database must also be backed up. When you have all your content as html files on your web server it is very easy to keep them safe from crashes, you just have a copy of them on your own PC and then upload them again after the web server is restored after the crash. This can be blogs, and a lot of other things. It is very important to do backup of your MySql database, you will probably realize it when it is too late.Ī lot of web applications use MySql for storing the content. How to backup your Mysql database with phpMyAdmin Stuff you never thought you wanted to know.īackup and Restore of MySql database with phpMyAdmin
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |