|
|
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
Navigation:
[Reply to this message]
|