Importing database over 50mb in cPanel?

15 years ago

1. do you still have access to the original DB?

Can you export single tables instead of the entire DB

if you have one table that is huge (over 50mb), then I would export as CSV and then write a php script to insert the data again. Export just the DB scheme, no data so you can create all the tables on the new DB. then export all the data as CSV and use the function "fgetcsv" to loop through each row and insert into new DB. you can split up the CSV into manageable counts to make it process faster

Thanks

{{ DiscussionBoard.errors[4672025].message }}

mywebwork

15 years ago

Splitting it up is the answer.

Your DB export as a text file that consists of two things - the CREATE TABLE statements for creating the tables and a number of INSERT statements to populate the tables with data.

If your export is over 50 MB then chances are the bulk of it is the INSERT statements.

Just split that file (using a text editor that can actually open such a large file) and upload it in the same sequence as the original file.

Otherwise get a host without such a limitation! One of the MySQL databases I'm maintaining right now is approaching 1.5 GB and I have no problems transferring that data back and forth.

Bill

Thanks

{{ DiscussionBoard.errors[4694578].message }}

lordspace

15 years ago

there are different options
1) compress the database scheme as much as possible.
I think phpMyAdmin supports zip,gzip,bz2 in addition to non-compresses .sql file.

2) connect using ssh and import it using
mysql -u username -p -h localhost dbname < data.sql

Thanks
1 reply

Signature

Are you using WordPress? Have you tried qSandbox yet?

{{ DiscussionBoard.errors[4695672].message }}

Tashi Mortier 15 years ago

You can also try using this:

Usage | BigDump: Staggered MySQL Dump Importer

Maybe it'll help. Then you can just upload the file to your webspace, enter the MySQL settings and let it have its way.
- Thanks
Signature

Want to read my personal blog? Tashi Mortier
{{ DiscussionBoard.errors[4710828].message }}

FraserJilani

15 years ago

Don't import it via any PHP based script. Just use SSH like lordspace suggested, if you don't have access to it just place the DB in a non public area of your server via FTP and ask your host to import it.

Thanks

{{ DiscussionBoard.errors[4710886].message }}

JimmyR

15 years ago

I think the ssh option will take forever but you can give it a go. Otherwise, just tar.gz it, write a php script to extract it on the server, then import it from there.

Thanks
1 reply

Signature

ChimpRewriter - The world's smartest and most powerful article rewriter - 7 day trial
Join hundreds of affiliates averaging $2.50 / click plus recurring comissions

{{ DiscussionBoard.errors[4711784].message }}

FraserJilani

15 years ago

Why would it take forever? It works much faster than any php based importer...

Originally Posted by JimmyR

I think the ssh option will take forever but you can give it a go. Otherwise, just tar.gz it, write a php script to extract it on the server, then import it from there.

Thanks

{{ DiscussionBoard.errors[4712419].message }}

JimmyR

15 years ago

Since the sql backup files are just a list of commands, I figured it would be running the individual commands one at a time over the connection which would surely add up to a ton of lag time with 50mb worth of commands. If this is not the case then I'm completely wrong.

Thanks
1 reply

Signature

ChimpRewriter - The world's smartest and most powerful article rewriter - 7 day trial
Join hundreds of affiliates averaging $2.50 / click plus recurring comissions

{{ DiscussionBoard.errors[4712799].message }}

FraserJilani

15 years ago

Yeah you are completely wrong.

Originally Posted by JimmyR

Since the sql backup files are just a list of commands, I figured it would be running the individual commands one at a time over the connection which would surely add up to a ton of lag time with 50mb worth of commands. If this is not the case then I'm completely wrong.

Thanks

{{ DiscussionBoard.errors[4713080].message }}

supershoesclub

15 years ago

If it is really a large database file after compress.I think it is better to upload it into the root of the web hosting by ftp with a clearn name.
After you do it, you should set up a new cron job which you can find in the main control panel in the bottom.
then:Enter an email address in the Email box and update it.
Click one of the Common Settings menus and select the appropriate interval, OR enter an interval using the Minute, Hour, Day, Month, and Weekday boxes.
Enter the command or script in the Command box like this:
mysql -u databse username -p password locahost < /home/public_html/yourdata.sql
then clink add.after your sql file is restored into your batabse.please remove this command in time.if not, it will restore again at that time you set.lol

Thanks

Signature

cheap fashion women bags

{{ DiscussionBoard.errors[4713443].message }}

jmartinez

15 years ago

Ok, so you backed up your current databases correct? I would do that first before doing any other procedure.

Using the terminal can be tedious and somewhat advanced for those without experience, but is probably the most direct route. 1 command will handle your import regardless of size. If you do go that route, be sure you understand what the command is doing and have a look at your db file that you are importing. Be sure everything looks correct.

Another easier, but more time consuming route would be to export 1 table at a time from the original db and import 1 table at a time into the new one using phpmyadmin. Assuming all tables are under the limit that should work as well.

Thanks

{{ DiscussionBoard.errors[4724736].message }}

starli88

15 years ago

Recently I have a huge database of 2.1GB for an article site and have to moved from another hosting to a Hostgator VPS. I understand your problem. Having to split the files and then importing the records. Big job and headache.

Luckily mine was a new add-on VPS and I was able to get Hostgator to transfer the big database and all my Wordpress sites to the VPS free of charge. It was done within 24 hours. Great job, Hostgator.

If yours is a new account and within 30 days of sign-up, you can get free transfer by using this link: http support.hostgator.com/articles/pre-sales-policies/hostgator-website-transfers (sorry not enough posts to enter links).

If over 30 days of sign-up, you can request for a quote for the transfer.

Edwin

Thanks

{{ DiscussionBoard.errors[4729640].message }}

webtechsharing

Banned 11 years ago

[DELETED]

{{ DiscussionBoard.errors[10472116].message }}

WarriorWasim

10 years ago

Hi, If you communicated with the technical support of Hostgator and if you are using VPSserver then they'll do it for free. You just need to upload the database to any directory. If you know a little bit of shell programming, you can do this by yourself. Thanks :-)

Thanks

{{ DiscussionBoard.errors[10609295].message }}

linux7802

10 years ago

Originally Posted by mondev

I'm trying to upload a database to one of my wordpress websites, and the database is over 50mb (about 250mb). I currently use HostGator hosting with cPanel, and the limit on the upload is 50mb.

How would I go about this?

Thanks in advance!

Don't waste your time and contact Hostgator support because by default upload limit from phpmyadmin is 50mb, therefore upload the database file ( i.e .sql file) under your hosting account and ask Hostgator tech to store it under your database

If they can't help you then its time to change Hosting

Thanks

Signature

â–ˆ KTCHost - E-commerce Ready Hosting | Pure SSD Cloud/VPS | Offshore Dedicated Server
â–ˆ cPanel Web Hosting - Free Website Builder | Unlimited Disk Space | 24/7 Support

{{ DiscussionBoard.errors[10609808].message }}

Importing database over 50mb in cPanel?

Trending Topics

Lightening strikes :(

Visual marketing ideas and concepts - How do I present myself to the marketing world?

If you had to start over today -- what would you do ?

" It is what it is" ... overused way too much imo

What would you do without the Internet ??