Posted by Chris Hope on 11/10/06 02:00

sTony wrote:

[snip]

> I had a thought, which can be dangerous, haha. Is is possible to
> store each table definition in it's own file, and then simply have one
> file that references all of the others? Like includes in other
> languages? If this is possible, it would have many advantages for me
> and my website. Anyone?
>
> Thanks in advance,

If you're using mysql and have command line access to the server where
the database is stored, you can always do this:

mysql -u[username] -p[password] [databasename] < *.sql

and it will pass all the .sql files in the current directory to the
mysql server and execute each one in turn. I'm sure there is a similar
method using postgres and other database servers.

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

[Back to original message]