Page Loader

Normal method that I do:

1. From phpmyadmin, click on database, export, save as file, then download the file into my computer.

2. On new server, from phpmyadmin, import, browse to the file downloaded from #1

That is fine for small file. Even though it says 50Mb is OK, but it will depends on the connection speed as well. I tried 27Mb and it’s not working.

So I tried another method:

1. From cpanel on old server, click to backup wizard, click backup, pick mysql databases, select the table, then the download will start.

2. Using my FTP client, upload the *.gz from Step 1 to a folder on my new server. Any folder.

3. Login to SSH, use this command:

gzip -d database_file_name.gz

So it turns to:
database_file_name.sql

4. Then use this command to restore database:

mysql -u user -p new_database_name < database_file_name.sql

Please note that new_database_name is created in advance using phpmyadmin on new server.

Comments
Leave a Reply

Your email address will not be published. Required fields are marked *

Highlights
Recent Posts
Instagram Feed
                                    #kitabakor
                                    Expecting to close above 10W average this week.. aminnn.
                                    https://scontent.cdninstagram.com/v/t51.2885-15/e35/s320x320/93973591_2583662348565050_5463274316583976513_n.jpg?_nc_ht=scontent.cdninstagram.com&_nc_ohc=SCqVn9_56SsAX-03AvC&oh=0aeb3e3611bd07f30b5025b2b8ba1860&oe=5ED4E562
                                    https://scontent.cdninstagram.com/v/t51.2885-15/e35/s320x320/93402322_532745040759024_6091110860798729703_n.jpg?_nc_ht=scontent.cdninstagram.com&_nc_ohc=7RnHu9UfBTEAX-i5QT6&oh=eacdd88fe9d7fdc2c9b6a85c6aa452ca&oe=5EFAEF7C
                                    https://scontent.cdninstagram.com/v/t51.2885-15/e35/s320x320/93100512_1537334973102603_72053284478751020_n.jpg?_nc_ht=scontent.cdninstagram.com&_nc_ohc=fZQBZyMXtxEAX_xdie6&oh=65066b1186bec3c91e0dc9fbd6e88cce&oe=5EFA2921
                                    #botolinone
#stayathomechallenge
#chipshotchallenge
                                    #1pahangnet2020
                                    #1pahangnet2020
                                    #1pahangnet2020