Outside the Cube (31)
Web publishing (134)
About this site
Links to us
General :: Databases
Database installation, programming and administration.
This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.
Generated 20:00:29 on Feb 26, 2020
How to run a *.sql script (mysql)
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
|Most recent comments