List:General Discussion« Previous MessageNext Message »
From:David T-G Date:December 17 2002 2:18pm
Subject:Re: How can I duplicate a mysql template database?
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Daevid --

...and then Daevid Vincent said...
% 
% > You mentioned a
% >   echo "<PRE>".$sql."</PRE><P>";
% > in your first post; what do you see?
% 
% I see exactly what I expected to see. Basically the contents of a db.sql
% file read in that looks like this roughly:

OK.  That's good, and now we know, too :-)  Of course, you're still using
fake examples instead of showing actual output...


...
% Etc.. Everything looks exactly like the .sql file does and the .sql file
% works perfectly if I redirect it in via the command line or even via an
% system() call.

OK.  BTW, if you can use a system call you should be able to use the
mysqldump suggestion from another reply.


% 
% > That's good, and we'll assume for the moment that your script doesn't
% > error through to die but instead makes a successful connection.
% 
% Yes. All that stuff works great.

Good.


% 
% > By the way, I see you quoting around your variables like
% >   print "This is " . $var . " here" ;
% 
% Yes, its' for readability in HomeSite. It color codes things, and that's
% a nice way to see it proper.

How interesting.  Thanks for the info!


% 
% > How does it fail?  Give us more detail.
% 
% With the error I posted earlier:
% 
% > 1064: You have an error in your SQL syntax near ';
% > CREATE TABLE Departments (
% >   DeptID int(10) unsigned NOT NULL auto_increment,' at line 4

Ah -- but you didn't post the resultant SQL statement that glued all of
this together so that we can see what line 4 is!


% 
% It's always on the second table. Order is irrelevant.
% Notice the ";" that it chokes on. That only happens when I separate the
% CREATE commands of course. But there is no other way to deliminate them.

My guess is that Joseph's suggestion that you can only do single commands
in a php mysql() command is probably right.


% 
...
% > No, that doesn't make sense.  It shouldn't matter how you create and
% > populate the variable, as long as the end result content is the same.
% > Since it works when you lay it out manually, it seems very 
% > probable that your filling it out in steps has some problems.
% 
% I think I'm right ;-)

Could be :-)


% 
% Try if for yourself and see what I mean. Just try to create a db and two
% tables and you'll see it choke.

Actually, while I do both php and mysql, I haven't yet done mysql from
php -- and so I'd be a lousy debugging source for that :-)


% 
% d 


HTH & HAND

mysql query,
:-D
- -- 
David T-G                      * There is too much animal courage in 
(play) davidtg@stripped * society and not sufficient moral courage.
(work) davidtgwork@stripped  -- Mary Baker Eddy, "Science and Health"
http://www.justpickone.org/davidtg/    Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE9/zJLGb7uCXufRwARArwuAKCtNoZX4597UW6Usg4GQU6DeUXx9ACdExlw
HZdcv7WV2BGJ66YvnWa1it0=
=n2o+
-----END PGP SIGNATURE-----
Thread
How can I duplicate a mysql template database?Daevid Vincent17 Dec
  • Re: How can I duplicate a mysql template database?Bill Lovett17 Dec
    • RE: How can I duplicate a mysql template database?Daevid Vincent17 Dec
      • RE: How can I duplicate a mysql template database? [hack]Daevid Vincent17 Dec
        • Re: How can I duplicate a mysql template database? [hack]Joseph Bueno17 Dec
          • RE: How can I duplicate a mysql template database? [hack]Daevid Vincent17 Dec
            • Re: How can I duplicate a mysql template database? [hack]Joseph Bueno17 Dec
      • Re: How can I duplicate a mysql template database?David T-G17 Dec
        • RE: How can I duplicate a mysql template database?Daevid Vincent17 Dec
          • Re: How can I duplicate a mysql template database?Joseph Bueno17 Dec
          • Re: How can I duplicate a mysql template database?David T-G17 Dec