12/8/2023 0 Comments Tableplus dump database![]() ![]() $ sudo mysqldump -u username -p -databases sales orders > sales_dump.sql Here is the command to backup sales and orders databases. $ sudo mysqldump -u username -p -all-databases > sales_dump.sql If you want to backup all databases on your server, use –all-databases option. If you want to backup only specific tables, mention it after the database name in MySQLdump command. $ sudo mysqldump -u username -p sales users products > sales_dump.sql Here is the command to backup tables users and products from sales database. Transfer backup to another database server $ sudo mysqldump -u username -p sales users -where="WHERE CLAUSE" > dump.sqlĢ. You can use any of the file transfer programs to copy. You need to run these commands from the source server where you have created the data dump file. We will use scp command for this purpose. ![]() Here is the command to transfer file sales_dump.sql to ip 54.43.32.21. TABLEPLUS MYSQL COPY DATABASE PASSWORDīut it is important that you have SSH access on this server, since you will need to enter username & password for access. ![]() Also, you need to have write access to the destination folder to be able to copy files to it. Replace 54.43.32.21 with IP address of destination server, root with your username on that server, and /home/ubuntu/sales with the folder location where you want the file to be saved. The last step is to create a new database from the data dump file. First, log into MySQL, create an empty database on the destination server, and exit it. Run the following command to copy data from. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |