homepage Welcome to WebmasterWorld Guest from 54.226.180.223
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Visit PubCon.com
Home / Forums Index / WebmasterWorld / Community Building and User Generated Content
Forum Library, Charter, Moderators: rogerd

Community Building and User Generated Content Forum

    
I need some help
a problem
B_ballPlaya




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

Hi,

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?

 

ExpLarry




msg:1557190
 8:28 pm on Jul 18, 2004 (gmt 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Community Building and User Generated Content
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved