self-running .sql-file from phpmyadmin?

j0sh

hi all.

i work (like many others) with phpmyadmin and i wanted to know if its possible to convert a .sql file of it to a "self-running" php-file that creates all the tables without loading it into phpmyadmin. i think this would be great if someone doesnt have phpmyadmin but wants to use a .sql-file.

anyone knows a way?

thx & gr33tz

j0sh

eoghain

You don't need the file to be self running.

Anyone with MySQL and access to the command line can just run the mysql shell and source the sql file and it will do all that it needs to do.

j0sh

thx. but isn't there a fast way to convert the sql file to a php file that you only have to open and then it installs all itself?

gr33tz

glassdog

You don't need the file to be self running. Anyone with MySQL and access to the command line can just run the mysql shell and source the sql file and it will do all that it needs to do

how is it done from mysql ???

HalfaBee

Just use the exec() command

if the file is on the server

exec( '/pathtomysql/mysql -uusername -ppassword -hhost DB_name < string.sql ' );

HalfaBee

j0sh

ok thank you!

eoghain

HalfaBee's answer:

exec( '/pathtomysql/mysql -uusername -ppassword -hhost DB_name < string.sql ' );

Is for running an sql script by the mysql interpreter from within PHP. A good example and shows how you would do this from the command line, but if you actually wanted to do it from within the mysql shell then you'd do this:

mysql>source string.sql

HalfaBee

When you are on a host that doesn't allow shell access thats all you can do 🙁

I didn't see the 'source' command in the manual.

HalfaBee

johncargill

Originally posted by j0sh
thx. but isn't there a fast way to convert the sql file to a php file that you only have to open and then it installs all itself?

gr33tz

my simple solution to this.

		$source = file_get_contents ("/export/home/user1/disco.sql");
		$querys = split(";",$source);
		array_pop($querys);			// skipping empty array after last ";"

		foreach ($querys as $query) {
			print "$query";
			$result = mysql_query($query) or die("MySQL source disco.sql : " . mysql_error());    
		}

leetcrew

Originally posted by johncargill
my simple solution to this.

		$source = file_get_contents ("/export/home/user1/disco.sql");
		$querys = split(";",$source);
		array_pop($querys);			// skipping empty array after last ";"

		foreach ($querys as $query) {
			print "$query";
			$result = mysql_query($query) or die("MySQL source disco.sql : " . mysql_error());    
		} [/B][/QUOTE]

that peace of code really helps 🙂
thanks

j0sh

thank you very much! 🙂
i'll try this!