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)

Inactive Member
Account Expired



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 July 18, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:May 10, 2004
votes: 0

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.


Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members