How to import big database tried bigdump script it got an error . Any suggestions

[rcep]

:hi:
i got a big database that cant be imported from phpmyadmin
i tried bigdump script it caused this error when i tried to import that big database

i dont have ssh accesss
any suggestions how to import that database


Thx

 

[Barrucadu]

Is the backup one huge SQL file? If so, try splitting it into smaller pieces and executing them in order.

 

[rcep]

when u have a 1gb database it will be a wast of time to split it down because it will take time to upload again in small chunks

anyways just found a way to solve this

Thx anyways

 

[Albino]

how did you fix it?

(out of curiousity)

 

[rcep]

script likie bigdump
actually bigdump also should work for big databases if you make it import them into small chunks

 

[SGBoise]

I recently had the same problem. They way I did was using secure shell with this command.

mysql -p -h DBSERVER dbname < dbname.sql


More info at http://www.modwest.com/help/kb6-241.html.

 

[justasiam]

when u have a 1gb database it will be a wast of time to split it down because it will take time to upload again in small chunks

anyways just found a way to solve this

Thx anyways

Can you please tell me how you resolved this?

 

[rcep]

when u have a 1gb database it will be a wast of time to split it down because it will take time to upload again in small chunks

anyways just found a way to solve this

Thx anyways

Can you please tell me how you resolved this?

Execute the following command in SSH: /usr/local/nf/bin/mysqldump -e --force --quick -h mysqlhost -u Username -pPassword DatabaseID tablename > tables.sql