How do you create a .sql file extension?

Hey Sureal,

So you have a file named with a .sql. A file of this sort is nothing more than a script that an SQL server can understand. Kind of like a shell script. Except it's executed using the SQL server instead of the shell.

The .sql files are good for backing-up your database or for initializing its structure for a project.

The following may vary depending on your OS.

mysql db_name < /path to file/file.sql

or you could try

mysql -e "source /path-to-file/file.sql" db_name

You can also log in to your mysql command line client and at the prompt type

source path-to-file/file.sql

Keep in mind that the path to the file is going to vary depending on whether your mySQL server is running on a Windows or *nix machine( "/", or "\" and the addition of "Dive Letter:\").

You can find out more concerning mySQL here:

http://dev.mysql.com/doc/refman/5.1/en/m...

Hope this was helpful.

Good Luck,

joe-

The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.

The Quomon Team