How to export 1GB .sql file?

Chris Worner

Well-known member
Registered
Joined
Apr 15, 2016
Messages
612
Points
28
Good evening
I have a blog run by WordPress, from phpAdmin I can not save the database because that is too large, around 1GB .sql file
Can you recommend a tool or a way that will be able to export a large db?
Thanks in advance.
 

LJSHost

Well-known member
Hosting Provider
Registered
Joined
Jul 5, 2016
Messages
1,031
Points
63
Hi Chris,

You have a couple of options.

If you are using cPanel you can use Backup > Download a MySQL Database Backup
You can also you mysqldump from the command line.

mysqldump -u root -p password wordpress_database > wordpress_database.sql
 

Chris Worner

Well-known member
Registered
Joined
Apr 15, 2016
Messages
612
Points
28
Chris Worner
Has mysqldump already installed on my VPS or I need to install it to use?

How to find root password of mysql?

where is wordpress_database.sql located after the command ran?
 

24x7CSM

Well-known member
Registered
Joined
Sep 27, 2016
Messages
263
Points
28
If you have root logins of the server then you can simple dump the database with mysqldump command , move that .sql file to a FTP location and download it on your local machine with FTP.
 

LJSHost

Well-known member
Hosting Provider
Registered
Joined
Jul 5, 2016
Messages
1,031
Points
63
Resetting the root MySQL can be done in a couple of ways

1. Control Panel
2. Command Line

Are you using WHM on your VPS ? If not I'll explain the command line method.
 

Chris Worner

Well-known member
Registered
Joined
Apr 15, 2016
Messages
612
Points
28
Chris Worner
Yes I am using WHM and cPanel on my VPS, I would like to export MYSQL database via command line method. Dong this via phpmyadmin is very slow and sometimes it's interrupted with large mysql databases.
 

LJSHost

Well-known member
Hosting Provider
Registered
Joined
Jul 5, 2016
Messages
1,031
Points
63
This will allow you to change the MySQL root password if you don't know what it is.

SQL Services > MySQL Root Password

When you run the mysqldump command it will output the .sql file in the current directory from where mysqldump was run, using my example.
 

Luxin Host

Well-known member
Registered
Joined
Jun 26, 2016
Messages
543
Points
43
Great advice given above in regards to exporting it, in the case of importing I would suggest using Big dump. It is not only reliable but also very simple to use.

I have been using it for some time now.
 

Maxoq

Well-known member
Registered
Joined
Feb 25, 2015
Messages
520
Points
28
Maxoq
I used Bigdump for importing database and it worked as well but never know how to use it for exporting a MySQL database.
 

stackstar

Member
Registered
Joined
Nov 22, 2016
Messages
30
Points
0
phpmyadmin usually has the option to export a GZIP compressed copy of the db which would shrink the size substantially. If you have command line access, as others have suggested, use mysqldump but you might be hitting a timeout configuration directive that is causing it to fail
 
Older Threads
Replies
6
Views
2,169
Replies
7
Views
2,711
Replies
2
Views
2,009
Replies
14
Views
9,039
Recommended Threads

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top