Excute a .sql File into a query

perrohunter

Hello

I was wondering how could i run in MySQL server a .sql file or a txt file that contains alot of query ( just like phpmyadmin does ) ? 🙂

thepeccavi

try using fopen()

example:

$query = fopen('filename.sql');

// Assume that we are connected to the DB

$results = mysql_query($query) or die("MySQL error! Please report it!<br />" . mysql_error());

// You can process these results now!

mikawhat

you mean import a .sql file?

perrohunter

yeah , exactly import ! ! 😃 😃

excuse my ugly english

mikawhat

ok. open the .sql file and copy all its contents. then go to phpmyadmin, select a database and click on 'SQL' tab. Do a paste in the textbox and click the button to execute the sql commands. After a couple of seconds all the newly created tables should be displayed at the left hand side menu, under the database name.

dr_bung

mysql -umy_user_name -p
enter password when prompted

USE my_db_name

SOURCE my_sql_filename

perrohunter

thx for the suggestions , but what im trying to do is create an script that executes the file :/

Can i mysql_query("SOURCE mysql_file.sql") ??

silasslack

I'm also in need of a solution to achieve this as I have an automatic regular export from .dbf files that I want to import as a query.

Any ideas? mysql_query("source file.sql") doesn't work (possibly because of the semicolons in the file)

Thanks!

www.silasslack.com

silasslack

If anyone has searched this, I've found a solution. You need to search through a .txt (or .sql) file line by line and store the lines into an array, then store the array to the table as normal:

$file_handle = fopen("STOCK.TXT", "rb");

	while (!feof($file_handle) ) {

	$line_of_text = fgets($file_handle);

	$parts = explode(';', $line_of_text);

$into = mysql_query($parts[0]);
if (!$into)
{
die('Could not import: ' . mysql_error());
}
}

silasslack

This works with any text file i believe, including .SQL files