importing 500mb sql file

[Treznax]

Hey,
Time to get my forum going again.

I have a 500mb database backup as my last backup of my forum. [Around that size anways].

What will be the quickest and easiest way of getting this backup imported into my database?

Note:
Don't bother saying phpmyadmin!

I was thinking BigDump but i dno

Treznax Reviewed by Treznax on 5th Sep 2009. importing 500mb sql file Hey, Time to get my forum going again. I have a 500mb database backup as my last backup of my forum. . What will be the quickest and easiest way of getting this backup imported into my database? Note: Don't bother saying phpmyadmin! Rating: 5

[William Palmer]

Hello Trez login into mysql and type this

mysql -u username -p dbname < /home/username/path-to-file.sql

and in a matter of seconds it will be imported


Enjoy

[Treznax]

Thx ill let you know how it goes

[William Palmer]

No problem i hope it helps if you do not have ssh access tell your host to execute what i stated above

[Chri5]

you can also use bigdump.php
google it

[desiboy]

you can also zip it and reduce the size.
if you dont have ssh access ..you can try bugdump or mysql dumper

[Curtis129]

compressing a database is not a good idea..

[SplitIce]

Hello Trez login into mysql and type this

mysql -u username -p dbname < /home/username/path-to-file.sql

and in a matter of seconds it will be imported


Enjoy

This is the best way, Im importing a 5gb db this way, takes about 30 mins tho for 5gb.

[Sp32]

Yeah, ssh is the way to go

phpbb is epic thorn in big toe