coryp Posted May 1, 2011 Share Posted May 1, 2011 Hi guys. New here and have a question. I don't phpadmin very well so I'm lost on how to accomplish this. I have a website and a database. I have a type of plugin with files to install and the last part of the instructions it says to "3. Restore the mySQL.sql file into your database." I was provided a mySQL.sql file and so somehow I need to get that into my current database. I just don't want to mess up the current database I have. How do I do this? I think it's appending to the database or overwriting olnypart of it?? I don't know really. Let me know if you have ideas. Thanks! Cory Quote Link to comment https://forums.phpfreaks.com/topic/235307-how-do-i-restore-mysqlsql-file-into-my-database/ Share on other sites More sharing options...
Muddy_Funster Posted May 2, 2011 Share Posted May 2, 2011 Open the .sql file with a text editor. copy and paste into PHPMyAdmin query panel and run it to perform the query, or paste it up here insode code tags if you want someone to explain what it's going to do before you run it. Quote Link to comment https://forums.phpfreaks.com/topic/235307-how-do-i-restore-mysqlsql-file-into-my-database/#findComment-1209334 Share on other sites More sharing options...
coryp Posted May 2, 2011 Author Share Posted May 2, 2011 Ok that sounds pretty easy. I don't have to do any specific syntax code or anything to run it right? Just bush GO? It won't mess up the current database other than append to it right? Quote Link to comment https://forums.phpfreaks.com/topic/235307-how-do-i-restore-mysqlsql-file-into-my-database/#findComment-1209480 Share on other sites More sharing options...
fenway Posted May 2, 2011 Share Posted May 2, 2011 That depends if you have a truncate/drop statement in there. And make sure your text editor is unicode-aware. Quote Link to comment https://forums.phpfreaks.com/topic/235307-how-do-i-restore-mysqlsql-file-into-my-database/#findComment-1209544 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.