Restoring a large database?

[10-7]

I have moved my site to my new server at JaguarPC. I am having some problems restoring my phpbb database however. According to the documentation I've read, I cannot upload a databse larger than 50 megs using phpmyadmin. I have also tried uploading the database through the phpbb - and I get an "action cancelled" message once it gets to about 50 Megs (I'm guessing it's around 50 megs where it dies... don't know for sure). My total database is about 120 Megs.

So... it says I can change the max upload number in the /home/phpmyadmin/config.inc.php file on line 72 , but I can't for the life of me find this file anywhere.

Now... first... is there an easier way to do this? Second, where can I find the config.inc.php file for phpmyadmin?

Any help is appreciated.

[Ron]

I can't answer your question directly, though I know others here probably can help you with that.

What I might suggest is loading the database manually from the command line in an SSH session.

It might look something like

mysql -u jagname_dbname -p < databasedumpfile.sql

Then you'd type in your password, and it would be off and running.

Not positive on the syntax, you might need to place the password inside the file on the first line. But maybe this will point you in a different direction that may work for you.

Good luck.

[10-7]

Ron,

Thanks for the quick reply, but that was way above my head. I'm very much a newbie at this. I am at the limits of my knowledge by looking through phpmyadmin to see if my database is there. I WAS able to upload my back-up database to the server, but for some reason, when I try to view it, I get a "tables not found" message.

Could you give me a little more basic explanation of what I should do?

Thanks

[Vin DSL]

mysql -u [username] -p [database] < yourbackup.sql

You will be prompted for [username]'s password.

[Vin DSL]

Originally posted by 10-7
Thanks for the quick reply, but that was way above my head. I'm very much a newbie at this....

Hrm... well, in that case I would contact Tech Support, via the ticket system. Explain your situation.

You can probably ZIP your db, and send it to them - or FTP it to your web space - and they will restore it for you. At least I'd give it a shot...

[Ron]

Originally posted by Vin DSL
mysql -u [username] -p [database] < yourbackup.sql

You will be prompted for [username]'s password.

It won't (mis)take [database] to be the pw? Cool. I would think it would need a "use <dbname>" inside the sql file.

But that's just me. Never done it here.

[JasonM]

Originally posted by Ron
It won't (mis)take [database] to be the pw? Cool. I would think it would need a "use <dbname>" inside the sql file.

But that's just me. Never done it here.

That is the correct syntax Vin DSL posted. You don't need a 'use dbname' statement.

[tank]

heres a helpful link. Learning about SSH was the best thing I've done

http://jaguarpc.com/forums/showthrea...threadid=10949

[jason]

Originally posted by 10-7
So... it says I can change the max upload number in the /home/phpmyadmin/config.inc.php file on line 72 , but I can't for the life of me find this file anywhere.

If you are using the CPanel version of PHPMyAdmin, it is a server-wide install and you can't access its configuration files , so you won't be able to change that. HTTP was designed to handle downloading, however, not uploading. Browser-based uploading is kind of an afterthought and is terribly unreliable for anything bigger than a few megs.

Upload your dump file to your account via FTP or SCP. Then log in with SSH and enter the command that Vin posted. That will give you the same result as what you are trying to accomplish via PHPMyAdmin.

If you don't know how to do any of these things, just ask and I (or one of the other "resident experts") will help you out however we can.

--Jason

[gerilya]

Originally posted by Ron
It won't (mis)take [database] to be the pw? Cool. I would think it would need a "use <dbname>" inside the sql file.

Actually, if you forget to add space after "-p" mysql will treat it as a password

[gerilya]

BTW, I don't think installing your own version of phpMyAdmin will help you much: in addition to limits set in phpMyAdmin's config file there are also server-wide limits in php.ini file that are not so easy to overcome.

[10-7]

I just wanted to update this and say that I got hold of tech support for this, and they were right on top of it.... they got the database restored for me in no time.

I have made myself a pledge to spend some time learning more about my new server and how to take care of it. For now though... I can't stress enough how awesome the tech folks are around here. Thanks Jaguarpc!

[Vin DSL]

Heh! He's hooked...