Large Database manage and import and export

How it could be to manage large database or split the file into deferent pieces ?

There is 300 MB database file .. I try to manage or use it for current website ..

But i am confused how to do it so .. what tools i need .. ?

Bigdump Php Script I have found but the file 300 MB is too large for the script to import it to mysql server.


So, there is 2 options

1. to split the file into pieces ..
2. to try to use the command in server by type the

and of course it can be first uploaded into server and using the bath of it by change it.

But the problem is i got this error !!

 

Could you show the first few lines of your dump, please?

 

i have imported 750mb databases using bigdump, your missing something or doing it to quickly, ie to many lines at a time.

for splitting files, try splitfile.exe

works great

 

Thanks, sawz

Yes .. thanks

 

Another way to do it would be to use the MySQL Administrator GUI (written by the folks at MySQL) thing...has a backup set which allows the importation and exporting of huge databases (I use it for a database on a daily basis that's about 1GB)... Works rather quickly.