BetaONE will rise again! - Inserting Mysql Database

BetaONE will rise again! (http:\\b1.hcanet.com\forum/index.php)

- Software Support (http:\\b1.hcanet.com\forum/forumdisplay.php?f=45)

- - Inserting Mysql Database (http:\\b1.hcanet.com\forum/showthread.php?t=6421)

I have recently moved hosts from Rockybar to WebHostingWeb the same as Allbetas and downloaded the sql database to copy over onto the new site. I keep trying to access phpmyadmin but if I click on the link I get "Action Cancelled" and if I open it in a new window I get "This page cannot be displayed". I have asked two friends in the USA to try to access it and upload the database and they can access it but when they try to upload the database they both get
Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/sqlparser.lib.php on line 264
I think it is because the database is too big because it is over 3MB. So one of the friends managed to upload it table by table but still can't upload the ibfposts table. He gets the same error, which might be because it is too big because that 1 table is over 1MB. So I have lost all my posts on the forums. When I contacted the company they weren't very helpful:( Is there anything I can do. They told me I should get shell access to do it so I said ok if they told me how to do it through that. They haven't replied though.
What can I do:(

robin, try this

1) delete everything in the imported database, yes, everything

2) upload your dump of the db to somewhere on the server (just make sure it is not http accessible!!!)

3) login to the shell

4) type

Quote:

mysql -u yourusername -p

hit enter, it will prompt you for your pass

5) enter your pass

6) type:

Quote:

use yourdbname;

and enter the command

7) type:

Quote:

source /path/to/your/db/dump/file/ext;

ie, if your db dump was backup.sql and your path to it was /home/robin/ , it would be source /home/robin/backup.sql (note, if you need to figure out the absolute path, type pwd at the shell right after you login, and it will show you the abs path to your home dir, and you can manage from there with ls and cd to list the dirs and change through them

that will go through and import your entire db.... if you need anymore help reply here or pm me :)

Thanks, I was wondering how to use shell. THey were telling me they had enabled shell and to do it through that but they wouldn't tell me how.