Databases (73)
InterBase (29)
MS-SQL (5)
mysql (37)
Oracle (1)
Linux (41)
Outside the Cube (4640)
Programming (679)
Web publishing (65)
Windows (431)
Exchange Links
About this site
How to run a *.sql script (mysql)
This article has not been rated yet. After reading, feel free to leave comments and rate it.
Question:
I am installing a .php based tool, and one of the final instructions is to "Run the mysql.sql script to create the necessary tables in the database.". How to I achieve this?Answer:
The *.sql file is a text file with SQL statements to be executed by the mysql server.You can run it through a tool like phpMyAdmin - just open a query window there and copy and paste the content of that text file in there. phpMyAdmin and possibly other frontends will also allow to upload a *.sql file through the web browser. In phpMyAdmin click on the SQL tab.
If you don't have any such front end installed, you can also go to the shell (assuming you're on a Linux box here). If your site is hosted somewhere, you'll need putty (or a similar tool) to connect to the server.
Ftp your *.sql file to the (remote) machine if not done yet.
Execute this command and you'll be fine:
mysql <my_db_name> -u<user_name> -p<password> <mysql.sql
|
||||||||
Comments:
