![]() The bzip2 -c after the | (pipe) means the backup is compressed on the fly, and the > 2 sends the bzip output to a file named 2.ĭespite bzip2 being able to compress most files more effectively than the older compression algorithms (.Z. You can do the same thing that above two commands do in one line: mysqldump -add-drop-table -h -u dbocodex -p wp | bzip2 -c > 2 Use bzip2 to compress the backup file bzip2 To backup only certain tables from the database mysqldump -add-drop-table -h mysql_hostserver -u mysql_username -p mysql_databasenameĮxample: mysqldump -add-drop-table -h -u dbocodex -p wp > To backup all database tables mysqldump -add-drop-table -h mysql_hostserver -u mysql_username -p mysql_databasename It prompts you to input password (For help, try: man mysqldump). PhpMyAdmin cannot handle large databases so using straight MySQL/MariaDB code will help.Ĭhange your directory to the directory you want to export backup to: cd the mysqldump command with your MySQL server name, user name and database name. Remember – you have NOT backed up the files and folders – such as images – but all your posts and comments are now safe. Depending on the database size, this may take a few moments. Now click ‘Go’ at the bottom of the window and you should be prompted for a file to download. Before table creation on target database, it will call DROP statement to delete the old existing table if it exist. Select Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement. In the Format-specific options section, leave options as they are. Unlike CSV or other data formats, this option exports a sequence of SQL commands. Select ‘zipped’ or ‘gzipped’ from Compression box to compress the data.Įnsure that the SQL is selected. If you only have your WordPress blog installed, leave it as is (or click ‘Select All’ if you changed the selection) The Output section They will be the ones with that start with “wp_” or whatever ‘table_prefix’ you specified in your ‘wp-config.php’ file. If you have other programs that use the database, then choose only those tables that correspond to your WordPress install. ![]() Detailed options are displayed.Īll the tables in the database are selected. If you want to change default behavior, select Custom backup.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |