Welcome to WebmasterWorld Guest from

Forum Moderators: rogerd

Message Too Old, No Replies

I need some help

a problem



7:49 pm on Jul 18, 2004 (gmt 0)


I don't really know which forum this should go in, and I don't know if you guys can help heh.

What i'm trying to do is install my old vbulletin database onto my computer so i can view old stuff. I have apache, php and mysql all installed onto my computer and running fine.

What I want to know is how do i get this 500MB .sql file where it should be so that i can view the tables through phpMyAdmin.

Does that make any sense?


8:28 pm on Jul 18, 2004 (gmt 0)

10+ Year Member

Does that make any sense?

sort of, although I think this belongs in the PHP/MySQL forum.

I'm assuming: your 500MB .sql file is a dump of your database, right? If so, you need this file on your computer somewhere. The "basic" way of reading it into your database using the command line (DOS prompt or what ever it's called these days) with the command:

mysql -u db_user db_name -p < large_file.sql

Change the parameters accordingly.

This may or may not work depending on what's in the .sql file; if it doesn't contain table definitions, you may need to add these first.

You might also want to watch out for how much free space you have, that 500MB may expand somewhat once it's read into the DB.


Featured Threads

Hot Threads This Week

Hot Threads This Month