How to export 1GB .sql file?

Chris Worner · Nov 19, 2016

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 · Nov 19, 2016

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

24x7CSM · Nov 19, 2016

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 · Nov 19, 2016

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.

LJSHost · Nov 19, 2016

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 · Nov 21, 2016

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.

stackstar · Nov 22, 2016

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

How to export 1GB .sql file?

Chris Worner

Well-known member

LJSHost

Well-known member

Chris Worner

Well-known member

24x7CSM

Well-known member

LJSHost

Well-known member

Chris Worner

Well-known member

LJSHost

Well-known member

Luxin Host

Well-known member

Maxoq

Well-known member

stackstar

Member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud