I have a database in .sql format, while restore the database to localhost all tables have unknown data. how can i delete all tables data before or after import.
i am using windows 7. mysql server 5.5
3
-
What is the machine you are doing this on? Server, Shared hosting? local machine - windows/unix or mac?Santosh Achari– Santosh Achari2015-01-08 09:17:35 +00:00Commented Jan 8, 2015 at 9:17
-
i am using windows 7Nagaraj Jayaraman– Nagaraj Jayaraman2015-01-08 09:35:50 +00:00Commented Jan 8, 2015 at 9:35
-
Just run the command I wrote in the answer on the command prompt.Santosh Achari– Santosh Achari2015-01-09 10:00:00 +00:00Commented Jan 9, 2015 at 10:00
Add a comment
|
3 Answers
phpmyadmin has an option for this task.
Select the database, you wish to export with empty tables
Click on Export
Select Custom in Export Method
Scroll down to Format-specfic options
Select Structure instead of Structure and data
Click on Go
That's all there is to it.
Comments
You could use this query to export database with no data:
mysqldump -u[USERNAME] -p[PASSWORD] --add-drop-table --no-data [DATABASE]
1 Comment
Santosh Achari
Alright, I understand you've just started with MySQL. You can run this command on Command prompt on windows or Terminal on mac.
if you have access to PhpMyAdmin http://localhost/phpmyadmin/ on your localhost simply login and drop the tables in the database you wish to import SQL dumps.
Then import the SQL dump file (.sql)
