TalkPHP - View Single Post

SOCK · 03-12-2008, 06:41 PM

You'll have to provide a bit more detail if you want a PHP script solution; in general, you would typically use either the 'mysql monitor' command line client or phpMyAdmin to load a database from an SQL file.

This of course could be emulated with a one-off PHP script that either parses the file and runs a query based on that, or perhaps uses exec() to run the correct MySQL command line client for the task at hand.

It's also possible a single query using LOAD DATA INFILE or SOURCE could be used.

03-12-2008, 06:41 PM	#2 (permalink)
SOCK The Acquainted Join Date: Nov 2007 Posts: 154 Thanks: 31	You'll have to provide a bit more detail if you want a PHP script solution; in general, you would typically use either the 'mysql monitor' command line client or phpMyAdmin to load a database from an SQL file. This of course could be emulated with a one-off PHP script that either parses the file and runs a query based on that, or perhaps uses exec() to run the correct MySQL command line client for the task at hand. It's also possible a single query using LOAD DATA INFILE or SOURCE could be used. __________________ I reject your reality, and substitute my own.