Restoring a large MySQL Database with cPanel - help?

[Rosie]

I do believe my database (a forum database from my previous server) is too large to restore with phpMyAdmin - it's about 76MB (it's got about 29,000 posts and a lot of mods). So I'm trying it with cPanel... I did the Backup/Restore with cPanel tutorial and I've gotten to the page that shows the little up arrow and the words "Restoring Database", but no tables or anything show up (in the tutorial, it shows someone restoring their site and a bunch of filenames show up as being successfully restored).

I'm also surfing phpMyAdmin and I see the database there, but it's empty. Is it just a matter of a large file taking a really long time, or is the file too big for the system? I've heard there are ways to break down large databases into smaller files, but I'm not sure how I'd go about doing this... I tried copying and pasting sections at a time (in order) into my current database but after I'd been working for three hours and only completed 5% of the database by copying and pasting, I decided just to try to restore the whole file at once. I really don't know if it's working, though.

I am really baffled as to the best way to go about doing this... I would really appreciate if someone could give me some advice! Thank you

[GatorBrent]

Upload your large database in sql format to your public_html folder

Once done email us your domain, username, password, your database name you have created, and the file name you have uploaded to public_html file name should be something.sql

We can then dump it in for you.

[Rosie]

Oh, goodness me. I am so terrible at this... I keep posting problems here and then solving them, and forgetting to follow up or delete my thread *blushes furiously* I am so sorry for the trouble - I've gotten everything straightened out, though. I backed up tables in the database individually and then broke down the ones that needed it, and my forum is up and running currently. Again, I am VERY sorry for the trouble!!! Thank you for your generosity, though, I think you are an excellent host

[Catwoman]

Originally Posted by GatorBrent

Upload your large database in sql format to your public_html folder

Once done email us your domain, username, password, your database name you have created, and the file name you have uploaded to public_html file name should be something.sql

We can then dump it in for you.

Can you do this for me? it would be a great help. I alrealdy have the sql file in my ftp.

[GatorJay]

Originally Posted by Catwoman

Can you do this for me? it would be a great help. I alrealdy have the sql file in my ftp.

Originally Posted by GatorBrent

Once done email us your domain, username, password, your database name you have created, and the file name you have uploaded to public_html file name should be something.sql

Email that information to support@hostgator.com

[riostyles]

Hello,
Had the same problem on an other host, much less user friendly as HG.
I used the attached script doing the import automacally per sizeable pieces, gz, or not, uses also FTP and have a drop. Basically PHP.
Runs like a simple GUI.
Works fine for me in IE6 and Firefox2.
BigDump
http://www.hotscripts.com/jump.php?l...22&jump_type=1

[rota919]

Thanks for this link I might be running into the same problem soon.

Will check it out later.

[debrag]

Originally Posted by GatorBrent

Upload your large database in sql format to your public_html folder

Once done email us your domain, username, password, your database name you have created, and the file name you have uploaded to public_html file name should be something.sql

We can then dump it in for you.

What do you mean by database name? my sql files are the name of the databases I was using on my old host, they start with a different name to the one I'd create directly with cpanel - xxx_gallery as I have a different username.
Does this mean that all my config files have to be changed?

[gtgeorge]

Originally Posted by debrag

What do you mean by database name? my sql files are the name of the databases I was using on my old host, they start with a different name to the one I'd create directly with cpanel - xxx_gallery as I have a different username.
Does this mean that all my config files have to be changed?

yes, all your db names that have changed will need to be updated in the config files. You may also need to recreate the users for the db after they have been set up.

[debrag]

So I need to set-up a new database in cpanel, import in phpmyadmin and then change all config files.

What is the database password? is it the one I set up for the user?

[Sam]

Originally Posted by debrag

What is the database password? is it the one I set up for the user?

Yes it is.

[debrag]

so

database created =
database name: 142323_gallery

user created =
user name: 142323_gallery1
user password: 142323_password

config =
dbserver: 'localhost'
dbuser: '142323_gallery1'
dbpass: '142323_password'
dbname: '142323_gallery'

would that config be a correct example?

Sorry for all the questions, I just don't want to lose things with the transfer

[Sam]

Originally Posted by debrag

so

database created =
database name: 142323_gallery

user created =
user name: 142323_gallery1
user password: 142323_password

config =
dbserver: 'localhost'
dbuser: '142323_gallery1'
dbpass: '142323_password'
dbname: '142323_gallery'

would that config be a correct example?

Sorry for all the questions, I just don't want to lose things with the transfer

You don't need to prefix the password with the cpanel username.

Everything else looks fine

[debrag]

thanks hopefully by tomorrow my site will be transfered & up and running

[Goddess Dix]

Originally Posted by Sam

You don't need to prefix the password with the cpanel username.

Everything else looks fine

and the prefix needs to be in your config, but when you create the database here, it will automatically add the prefixs for you, so don't put them in the db or user name yourself. otherwise it will be prefix_prefix_name.

[gtgeorge]

And if it is a large database, you will need to get HG to import it for you! Or use some third party tools to do it, if you want to do it yourself.

[local64]

Originally Posted by gtgeorge

And if it is a large database, you will need to get HG to import it for you! Or use some third party tools to do it, if you want to do it yourself.

Hey Guys,
So what kind of program I can use to upload database?
Working with 2mb+ databases.
20+ separate databases.

Will be a hastle to email HG every time we need to upload a database.

Restore database form Cpanel doesn't work at all.. get stucked with same massage "Restoring Database"..

PLEASE ANY ADVICE!
Ready to move to another host if it's not gonna work out with HG....

[striddy]

Originally Posted by local64

So what kind of program I can use to upload database?

A FTP client, like FileZilla (free) or many others.

Originally Posted by local64

Working with 2mb+ databases.

That's not big at all.

Originally Posted by local64

Restore database form Cpanel doesn't work at all.. get stucked with same massage "Restoring Database"..

Did you try phpMyAdmin?

Also, rather than dragging up such an old post, best to start a new thread.

[toastedhost]

I would like to learn to do this myself via... cPanel > Backups > Restore a MySQL Database. Is there an Up-to-Date tutorial somewhere. I can't seem to find one.

thanks,

[local64]

Originally Posted by striddy

A FTP client, like FileZilla (free) or many others.



That's not big at all.



Did you try phpMyAdmin?

Also, rather than dragging up such an old post, best to start a new thread.

Sorry about old post.
Anyway. I belive phpMyAdmin got 2mb limit on database import...no?

[quietFinn]

Originally Posted by local64

Sorry about old post.
Anyway. I belive phpMyAdmin got 2mb limit on database import...no?

No.
It's 51200 kB.

[RFiend]

I use the BigDump script the person in post #6 mentioned (really large forums).

One word of warning, though: if your database is UTF-8, you must change one line in bigdump.php (see below). Looks like the default collation here at HG is set to utf8_unicode_ci, which is nicer for those of us that use UTF-8. By forcing it in the script, I don't have to worry what the host is defaulted to. Other hosts I've seen defaulted to one of the ISO LATIN collations, which mangles UTF-8.

$db_connection_char_set = 'utf8';

[afaikIwin]

Originally Posted by iamtheweb

Thanks, I actually have the same problem and this is a good thing to keep in mind here http://forexdaytradertips.com/images...orgreeting.gif

I agree.
I've been searching for a script for a long time and it was right under my nose basically!

[gwyneth]

afaikIwin, please remove the hidden image/link from your signature. You are allowed to use visible images and links there.

Your quoted text also includes a hidden image/link that was in the (removed) post you quote. Is it just a coincidence that both involve the same Gator smiley?

[GvilleRick]

I suspect we may soon see a couple of new members in the Banned User group.