How to run .sql file?

[Oni]

Hey,

I have a .sql file which has mysql commands. I would have runned the file in phpmyadmin by because I don't have that tool I cant. Anyone know how I can execute the .sql file?

I tried turning each of the commands into php ones but that didn't work. And yes, I didn't forget to connect to the database 😉

Thanks!

[thorpe]

mysql> SOURCE file.sql;

[Oni]

I don't have shell/telnet access if you're talking about running a command?

If you're not, I'm lost 🙁

[thorpe]

You run mysql queries through mysql_query. So, the example above translates into...

// connect to db.
if (mysql_query("SOURCE file.sql")) {
  echo "success";
}

[Oni]

Neat trick 😃
Thanks!

[MarkR]

Even if you don't have shell access (an intolerable condition IMHO), if you have remote access to the database you can just run the relevant mysql command locally.

Mark

[m4niac]

does anyone know why if running from windows cmd with full path to file works fine but when trying to achieve the same thing with a php script fails? im running zend server CE on a local machine

[bradgrafelman]

Show us the code you're using in the PHP script.