Jump to content

.SQL into MySQL

- - - - -
Started by Guest_Lop_* , Aug 08 2007 05:21 AM

This topic has been archived. This means that you cannot reply to this topic.
3 replies to this topic

#1
Guest_Lop_*
Posted 08 August 2007 - 05:21 AM

Guest_Lop_*
  • Guests
In a shell prompt how do I import a .SQL file into MySQL? I need to restore a test database that has gone bad.

#2
Guest_Jordan_*
Posted 08 August 2007 - 05:48 AM

Guest_Jordan_*
  • Guests
I've had to do this a lot for the users on my server. Once you have the dump it is always easiest to go through phpMyAdmin if possible but here is the shell command:

mysql -u USER -p DBNAME < dump.sql

#3
Guest_Lop_*
Posted 14 August 2007 - 05:56 AM

Guest_Lop_*
  • Guests
That works. How do I get it out in the .SQL file from shell?

#4
Guest_Jordan_*
Posted 14 August 2007 - 10:01 AM

Guest_Jordan_*
  • Guests
mysqldump -u <username> -p <database_name> > sqlfile.sql
Back to Linux Applications




  1. CODECALL Programming Forum
  2. → General Computing
  3. → Linux and Unix
  4. → Linux Applications
IPB skins by Skinbox