eternalistic Posted February 25, 2005 Share Posted February 25, 2005 Im having trouble importing my SQL database into a fresh install of OSC. I did a backup of the entire site through the Admin panel ( Tools > Database Backup Manager) I have that file and did a fresh install of OSC with a new database server, username, password etc, but still using the same host. When I try to restore the database to what I had backed up nothing happens. It acts like its thinking but goes nowhere. What is the easiest way to get my backed up database information working on the new install? Thanks for any help.. -Jeremy ? ? ? ? ? ? ? ? ? ? ? ? ? www.eternalistic.net ? ? ? ? ? ? ? ? ? ? ? ? ? ? Link to comment Share on other sites More sharing options...
Guest Posted February 25, 2005 Share Posted February 25, 2005 Do you have phpMyAdmin? Link to comment Share on other sites More sharing options...
eternalistic Posted February 25, 2005 Author Share Posted February 25, 2005 Do you have phpMyAdmin? <{POST_SNAPBACK}> Good idea, I completely forgot about that program. Ill give it a shot and report back here, thanks. -Jeremy ? ? ? ? ? ? ? ? ? ? ? ? ? www.eternalistic.net ? ? ? ? ? ? ? ? ? ? ? ? ? ? Link to comment Share on other sites More sharing options...
eternalistic Posted February 25, 2005 Author Share Posted February 25, 2005 Ive got phpMyAdmin installed and I cant figure out how to get my .sql file imported to the database. Ive read some of the readme's but no luck.. ? ? ? ? ? ? ? ? ? ? ? ? ? www.eternalistic.net ? ? ? ? ? ? ? ? ? ? ? ? ? ? Link to comment Share on other sites More sharing options...
Guest Posted February 25, 2005 Share Posted February 25, 2005 Ive got phpMyAdmin installed and I cant figure out how to get my .sql file imported to the database. Ive read some of the readme's but no luck.. <{POST_SNAPBACK}> First select your database (if not already selected). Then click SQL (should be near the top of the page). Should be quite easy from there. - Ray - Link to comment Share on other sites More sharing options...
Guest Posted February 25, 2005 Share Posted February 25, 2005 P.S. If you haven't already created a blank database and set new username/password with all privileges. Then do that first. Link to comment Share on other sites More sharing options...
Guest Posted February 26, 2005 Share Posted February 26, 2005 Also, if you have a big shop, check to see if you used "extended inserts" when you did the backup. Extended inserts will have MUCH longer "insert" statements instead of each table row getting its own insert statement. If you have really long insert statements, sometimes imports can take too long and time out. -jared Link to comment Share on other sites More sharing options...
eternalistic Posted February 28, 2005 Author Share Posted February 28, 2005 I was able to insert the sql dump into the database through SSH and everything works perfectly now, thanks for the help. -Jeremy ? ? ? ? ? ? ? ? ? ? ? ? ? www.eternalistic.net ? ? ? ? ? ? ? ? ? ? ? ? ? ? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.