How to export 1GB .sql file?

Chris Worner

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.
 
L

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

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

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.
 
L

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

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.
 
L

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

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

Maxoq

Well-known member
Registered
Joined
Feb 25, 2015
Messages
535
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

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
 
You must log in or register to reply here.
Older Threads
Cheerag Nundlall
What is a domain alias?
Replies
6
Views
3,418
Collabora
Ben Newman
How To Upgrade CentOS 6 to CentOS 7
Replies
6
Views
4,390
eva2000
E
Dedicated hosting or small business hosting?
Replies
7
Views
4,206
ForwardWeb
T
C++ app on linux via PHP
Replies
2
Views
2,949
stackstar
hostomy
Cheap + Best Domain Reseller?
Replies
14
Views
12,084
CertaHosting
Newer Threads
Mujkanovic
The Best eCommerce Platform for WordPress?
Replies
12
Views
7,668
energizedit
TheCompWiz
Best Hosting Solution for a Private Blog Network
Replies
5
Views
3,792
stackstar
HostColor
HOT Host Color - US DEDICATED - Intel Xeon E3-1230v3 - 100 Mbps UNMETERED
Replies
0
Views
3,486
HostColor
Emily Routledge
Does web hosting affect search results?
2
Replies
24
Views
10,540
jerryperes
regularjoe
Linux basic commands with examples
Replies
4
Views
3,585
mondoserv
Latest Threads
VPS Circlejerk
Hey ForumWeb, happy to be here
Replies
3
Views
1,841
ITivan80
M
Hello Everyone – I'm Glad to Join
Replies
4
Views
393
HostOX
hetnix_srl
ENGINYRING - Your Alternative to Corporate Hosting Giants
Replies
2
Views
321
hetnix_srl
V
Radius Control Panel with WHMCS Integration
Replies
2
Views
317
VPNOps
HostAddon
Hostaddon VPS/VDS | EU/US/ASIA | 25/10/2/1 Gbps | SSD NVMe | Upto 50% Off | Storage | DMCA...
Replies
2
Views
520
HostAddon
Recommended Threads
Dr. McKay
Hetzner vs OVH
2 3
Replies
45
Views
42,928
MajorGap
steitieh
is Namecheap.com an Enom reseller?
Replies
9
Views
12,084
NameHero
Starfire
Better website design for better traffic?
Replies
5
Views
4,986
dipincome
DaRecordon
Vimeo Pro vs Amazon s3?
Replies
1
Views
6,267
instacarma
R
HELP! I’m looking for a web host!!
Replies
17
Views
7,256
coolhandle
Similar Threads
HostAddon
Hostaddon - EU/US/ASIA | 1Gbit/10Gbit Unmetered Servers | Start @$14.99 | Additional 10% Off [Paid]
Replies
0
Views
848
HostAddon
systeminplace
SystemInPlace - Low cost Dual E5 384GB/512GB RAM DEDI. 30% OFF FIRST MONTH! 1gb/2.5gb/5gb/10gb
Replies
2
Views
1,466
systeminplace
Gmeister4
Is it possible to export a Mysql database via SSH?
Replies
11
Views
7,726
AlbaHost
FerdieQO
Exporting selected rows in phpMyAdmin?
Replies
1
Views
9,740
Dr. McKay
A
SonataadminBunlde Symfony2 : ExportFields date
Replies
0
Views
2,427
Adriana14

Latest postsNew threads

Latest Hosting OffersNew Reviews

Popular Contributors - Past 30 Days

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.
  • cpanel
  • dedicated
  • free
  • hello
  • hosting
  • hosting services
  • marketing
  • offers
  • seo
  • server
  • services
  • vps
  • web
  • web hosting
  • website
  • wordpress
    • Top