Import MYSQL table information from .sql file

[Brad Brevet]

If I have created a .sql file in my notepad named tables.sql and laved it in
my inetpub folder what commands do I have to enter at the mySQL command
prompt to get it to import the table information into my database?

Thanks for any help,

Brad

[Ed]

try here:

[url]http://www.mysql.com/doc/en/mysqlimport.html[/url]


On Sat, 19 Jul 2003 18:52:54 -0700, "Brad Brevet"
<bradbrevet@hotmail.com> wrote:

>If I have created a .sql file in my notepad named tables.sql and laved it in
>my inetpub folder what commands do I have to enter at the mySQL command
>prompt to get it to import the table information into my database?
>
>Thanks for any help,
>
>Brad
>

[Joseph Szobody]

mysql -u username -p -vvv < tables.sql

Joseph

"Brad Brevet" <bradbrevet@hotmail.com> wrote in message news:bfcsog$e5p$1@forums.macromedia.com...

> If I have created a .sql file in my notepad named tables.sql and laved it in
> my inetpub folder what commands do I have to enter at the mySQL command
> prompt to get it to import the table information into my database?
>
> Thanks for any help,
>
> Brad
>
>

[Paul Taylor]

On Sun, 20 Jul 2003 03:05:31 GMT, Ed <ed.nospam@mind.spring.com>
wrote:

>try here:
>
>[url]http://www.mysql.com/doc/en/mysqlimport.html[/url]
>
>
>On Sat, 19 Jul 2003 18:52:54 -0700, "Brad Brevet"
><bradbrevet@hotmail.com> wrote:
>

>>If I have created a .sql file in my notepad named tables.sql and laved it in
>>my inetpub folder what commands do I have to enter at the mySQL command
>>prompt to get it to import the table information into my database?
>>
>>Thanks for any help,
>>
>>Brad
>>

If you use a GUI, like dbmanager ([url]www.dbtools.com.br[/url]) or phpmyadmin
([url]www.phpmyadmin.net[/url]), it becomes easy to import. I'm a bit lazy,
myself - I try to avoid the command line if I can.


Paul Taylor

[Philip Ladin]

I am using MYSQL and have multiple databases. I can write code to connect to
one database or the other. How do I write a sql statement that will allow me
to access tables in two different databases?

Thank You...

[Philip Ladin]

I am using MYSQL and have multiple databases. I can write code to connect to
one database or the other. How do I write a sql statement that will allow me
to access tables in two different databases?

Thank You...

[Michael Rasmussen]

Den Fri, 10 Oct 2003 15:28:37 -0400. skrev Philip Ladin:

> I am using MYSQL and have multiple databases. I can write code to connect
> to one database or the other. How do I write a sql statement that will
> allow me to access tables in two different databases?
>
> Thank You...

You create two connections and remembers to add which connection every
request should go to.

$link1 = mysql_connect("localhost", "mysql_user", "mysql_password")
or die("Could not connect: " . mysql_error());
print ("Connected successfully");
mysql_close($link);
$link2 = mysql_connect("localhost", "mysql_user", "mysql_password")
or die("Could not connect: " . mysql_error());
print ("Connected successfully");
mysql_close($link);
mysql_select_db("foo",$link1);
mysql_select_db("bar",$link2);

mysql_query("select * from table1", $link1);
mysql_query("select * from table1", $link2);

etc.

--
Hilsen/Sincerely, Michael Rasmussen

En windows admin er en person, for hvem den største bedrift er, at
lave konfiguration af serveren med trial and error via en gui.

[Philip Ladin]

Thank you...

"Michael Rasmussen" <mir@datanom.net> wrote in message
news:pan.2003.10.10.19.55.20.227967@datanom.net...

> Den Fri, 10 Oct 2003 15:28:37 -0400. skrev Philip Ladin:
>

> > I am using MYSQL and have multiple databases. I can write code to

connect

> > to one database or the other. How do I write a sql statement that will
> > allow me to access tables in two different databases?
> >
> > Thank You...

> You create two connections and remembers to add which connection every
> request should go to.
>
> $link1 = mysql_connect("localhost", "mysql_user", "mysql_password")
> or die("Could not connect: " . mysql_error());
> print ("Connected successfully");
> mysql_close($link);
> $link2 = mysql_connect("localhost", "mysql_user", "mysql_password")
> or die("Could not connect: " . mysql_error());
> print ("Connected successfully");
> mysql_close($link);
> mysql_select_db("foo",$link1);
> mysql_select_db("bar",$link2);
>
> mysql_query("select * from table1", $link1);
> mysql_query("select * from table1", $link2);
>
> etc.
>
> --
> Hilsen/Sincerely, Michael Rasmussen
>
> En windows admin er en person, for hvem den største bedrift er, at
> lave konfiguration af serveren med trial and error via en gui.
>

[Pedro]

Philip Ladin wrote:

> I am using MYSQL and have multiple databases. I can write code to connect to
> one database or the other. How do I write a sql statement that will allow me
> to access tables in two different databases?

multiple databases on the same server? easy :-)

<?php
$conn = mysql_connect('server', 'user', 'pass');


$sql = "select a.col1, a.col2, b.col2, b.col3"
. "from db1.table a, db2.table b" # a is in db1; b is in db2
. "where a.id=b.id";


$res = mysql_query($sql);
echo '<table>';
while ($row = mysql_fetch_row($res)) {
echo '<tr>';
foreach ($row as $x) {
echo "<td>$x</td>";
}
echo '</tr>';
}
echo '</table>';
?>

--
I have a spam filter working.
To mail me include "urkxvq" (with or without the quotes)
in the subject line, or your mail will be ruthlessly discarded.

[Philip Ladin]

Thank you...
"Pedro" <hexkid@hotpop.com> wrote in message
news:bm75dt$jcgkf$1@ID-203069.news.uni-berlin.de...

> Philip Ladin wrote:

> > I am using MYSQL and have multiple databases. I can write code to

connect to

> > one database or the other. How do I write a sql statement that will

allow me

> > to access tables in two different databases?

>
> multiple databases on the same server? easy :-)
>
> <?php
> $conn = mysql_connect('server', 'user', 'pass');
>
>
> $sql = "select a.col1, a.col2, b.col2, b.col3"
> . "from db1.table a, db2.table b" # a is in db1; b is in db2
> . "where a.id=b.id";
>
>
> $res = mysql_query($sql);
> echo '<table>';
> while ($row = mysql_fetch_row($res)) {
> echo '<tr>';
> foreach ($row as $x) {
> echo "<td>$x</td>";
> }
> echo '</tr>';
> }
> echo '</table>';
> ?>
>
> --
> I have a spam filter working.
> To mail me include "urkxvq" (with or without the quotes)
> in the subject line, or your mail will be ruthlessly discarded.

[Alan Little]

Carved in mystic runes upon the very living rock, the last words of
Philip Ladin of alt.comp.lang.php make plain:

> I am using MYSQL and have multiple databases. I can write code to
> connect to one database or the other. How do I write a sql statement
> that will allow me to access tables in two different databases?

I'm not a total MySQL expert, but I believe the short answer is: you can't.

--
Alan Little
Phorm PHP Form Processor
[url]http://www.phorm.com/[/url]

[Paulus Magnus]

"Philip Ladin" <philipl@amalla.com> wrote in message
news:R_Ehb.31144$Sn1.11518@bignews4.bellsouth.net. ..

> Thank you...
> "Pedro" <hexkid@hotpop.com> wrote in message
> news:bm75dt$jcgkf$1@ID-203069.news.uni-berlin.de...

> > Philip Ladin wrote:

> > > I am using MYSQL and have multiple databases. I can write code to

> connect to

> > > one database or the other. How do I write a sql statement that will

> allow me

> > > to access tables in two different databases?

> >
> > multiple databases on the same server? easy :-)
> >
> > <?php
> > $conn = mysql_connect('server', 'user', 'pass');
> >
> >
> > $sql = "select a.col1, a.col2, b.col2, b.col3"
> > . "from db1.table a, db2.table b" # a is in db1; b is in db2
> > . "where a.id=b.id";
> >
> >
> > $res = mysql_query($sql);
> > echo '<table>';
> > while ($row = mysql_fetch_row($res)) {
> > echo '<tr>';
> > foreach ($row as $x) {
> > echo "<td>$x</td>";
> > }
> > echo '</tr>';
> > }
> > echo '</table>';
> > ?>

I would also suggest that a requirement to query across databases means that
your database structure has been poorly designed.

Paulus

[Tom Thackrey]

On 10-Oct-2003, Alan Little <alan@n-o-s-p-a-m-phorm.com> wrote:

> > I am using MYSQL and have multiple databases. I can write code to
> > connect to one database or the other. How do I write a sql statement
> > that will allow me to access tables in two different databases?

>
> I'm not a total MySQL expert, but I believe the short answer is: you
> can't.

If the databases are on the same server you can.

select * from db1.table1, db2.table2 where
db1.table1.field1=db2.table2.field2

--
Tom Thackrey
[url]www.creative-light.com[/url]
tom (at) creative (dash) light (dot) com
do NOT send email to [email]jamesbutler@willglen.net[/email] (it's reserved for spammers)

[James]

On Sat, 11 Oct 2003 06:53:44 +0000 (UTC), "Paulus Magnus"
<paulus.magnus@loves-spam.com> scrawled:

>"Philip Ladin" <philipl@amalla.com> wrote in message
>news:R_Ehb.31144$Sn1.11518@bignews4.bellsouth.net ...

>> Thank you...
>> "Pedro" <hexkid@hotpop.com> wrote in message
>> news:bm75dt$jcgkf$1@ID-203069.news.uni-berlin.de...

>> > Philip Ladin wrote:
>> > > I am using MYSQL and have multiple databases. I can write code to

>> connect to

>> > > one database or the other. How do I write a sql statement that will

>> allow me

>> > > to access tables in two different databases?
>> >
>> > multiple databases on the same server? easy :-)
>> >
>> > <?php
>> > $conn = mysql_connect('server', 'user', 'pass');
>> >
>> >
>> > $sql = "select a.col1, a.col2, b.col2, b.col3"
>> > . "from db1.table a, db2.table b" # a is in db1; b is in db2
>> > . "where a.id=b.id";
>> >
>> >
>> > $res = mysql_query($sql);
>> > echo '<table>';
>> > while ($row = mysql_fetch_row($res)) {
>> > echo '<tr>';
>> > foreach ($row as $x) {
>> > echo "<td>$x</td>";
>> > }
>> > echo '</tr>';
>> > }
>> > echo '</table>';
>> > ?>

>
>I would also suggest that a requirement to query across databases means that
>your database structure has been poorly designed.
>

May not be - it may be that you have a core of data in one database, and
that you have a number of optional additional data in a number of satellite
databases, these all have a common schema but may be produced in house,
or obtained from external sources.

This allows for the arbitrary combination of data from a number of
different sources without having to have the bastardisation of table names
to produce table "mydata_feature" instead of "mydata.feature".

On a large project I work on (not in PHP) we do this a lot to achieve quite
complex data manipulations (at the last count we were placing over
100Gbytes of data in the public domain)

But we also have a layer that can do this join in software rather than
using the niceness of using MySQLs database join features - it just results
in a lot more queries a lot more code and a loss of speed, but does work
when the databases are not collocated.

[Paulus Magnus]

"James" <newsgroup@black-panther.freeserve.co.uk> wrote in message
news:3f87b403.98111186@news.freeserve.com...

> On Sat, 11 Oct 2003 06:53:44 +0000 (UTC), "Paulus Magnus"
> <paulus.magnus@loves-spam.com> scrawled:
>

> >"Philip Ladin" <philipl@amalla.com> wrote in message
> >news:R_Ehb.31144$Sn1.11518@bignews4.bellsouth.net ...

> >> Thank you...
> >> "Pedro" <hexkid@hotpop.com> wrote in message
> >> news:bm75dt$jcgkf$1@ID-203069.news.uni-berlin.de...
> >> > Philip Ladin wrote:
> >> > > I am using MYSQL and have multiple databases. I can write code to
> >> connect to
> >> > > one database or the other. How do I write a sql statement that will
> >> allow me
> >> > > to access tables in two different databases?
> >> >
> >> > multiple databases on the same server? easy :-)
> >> >
> >> > <?php
> >> > $conn = mysql_connect('server', 'user', 'pass');
> >> >
> >> >
> >> > $sql = "select a.col1, a.col2, b.col2, b.col3"
> >> > . "from db1.table a, db2.table b" # a is in db1; b is in db2
> >> > . "where a.id=b.id";
> >> >
> >> >
> >> > $res = mysql_query($sql);
> >> > echo '<table>';
> >> > while ($row = mysql_fetch_row($res)) {
> >> > echo '<tr>';
> >> > foreach ($row as $x) {
> >> > echo "<td>$x</td>";
> >> > }
> >> > echo '</tr>';
> >> > }
> >> > echo '</table>';
> >> > ?>

> >
> >I would also suggest that a requirement to query across databases means

that

> >your database structure has been poorly designed.
> >

>
> May not be - it may be that you have a core of data in one database, and
> that you have a number of optional additional data in a number of

satellite

> databases, these all have a common schema but may be produced in house,
> or obtained from external sources.

Very true, I just think in the majority of cases (99% of all the occasions
that I've seen it) that using more than one database is an indication of a
poorly designed data structure.

Paulus

[Rohan Hawthorne]

Alternitavely if they are on different servers you can do a lot of work
in the code.

-----Original Message-----
From: Tom Thackrey [mailto:use.signature@nospam.com]
Posted At: Saturday, 11 October 2003 4:38 PM
Posted To: php
Conversation: MYSQL Question
Subject: Re: MYSQL Question



On 10-Oct-2003, Alan Little <alan@n-o-s-p-a-m-phorm.com> wrote:

> > I am using MYSQL and have multiple databases. I can write code to
> > connect to one database or the other. How do I write a sql statement

> > that will allow me to access tables in two different databases?

>
> I'm not a total MySQL expert, but I believe the short answer is: you
> can't.

If the databases are on the same server you can.

select * from db1.table1, db2.table2 where
db1.table1.field1=db2.table2.field2

--
Tom Thackrey
[url]www.creative-light.com[/url]
tom (at) creative (dash) light (dot) com
do NOT send email to [email]jamesbutler@willglen.net[/email] (it's reserved for
spammers)

[Philip Ladin]

I agree with you that in most cases, spreading data across disparate
databases is a poor design. In my case, I was converting some data from
different sources and was writing some maintenance scripts....

"Paulus Magnus" <paulus.magnus@loves-spam.com> wrote in message
news:bm8dlg$m2h$1@titan.btinternet.com...

>
> "James" <newsgroup@black-panther.freeserve.co.uk> wrote in message
> news:3f87b403.98111186@news.freeserve.com...

> > On Sat, 11 Oct 2003 06:53:44 +0000 (UTC), "Paulus Magnus"
> > <paulus.magnus@loves-spam.com> scrawled:
> >

> > >"Philip Ladin" <philipl@amalla.com> wrote in message
> > >news:R_Ehb.31144$Sn1.11518@bignews4.bellsouth.net ...
> > >> Thank you...
> > >> "Pedro" <hexkid@hotpop.com> wrote in message
> > >> news:bm75dt$jcgkf$1@ID-203069.news.uni-berlin.de...
> > >> > Philip Ladin wrote:
> > >> > > I am using MYSQL and have multiple databases. I can write code to
> > >> connect to
> > >> > > one database or the other. How do I write a sql statement that

will

> > >> allow me
> > >> > > to access tables in two different databases?
> > >> >
> > >> > multiple databases on the same server? easy :-)
> > >> >
> > >> > <?php
> > >> > $conn = mysql_connect('server', 'user', 'pass');
> > >> >
> > >> >
> > >> > $sql = "select a.col1, a.col2, b.col2, b.col3"
> > >> > . "from db1.table a, db2.table b" # a is in db1; b is in

db2

> > >> > . "where a.id=b.id";
> > >> >
> > >> >
> > >> > $res = mysql_query($sql);
> > >> > echo '<table>';
> > >> > while ($row = mysql_fetch_row($res)) {
> > >> > echo '<tr>';
> > >> > foreach ($row as $x) {
> > >> > echo "<td>$x</td>";
> > >> > }
> > >> > echo '</tr>';
> > >> > }
> > >> > echo '</table>';
> > >> > ?>
> > >
> > >I would also suggest that a requirement to query across databases means

> that

> > >your database structure has been poorly designed.
> > >

> >
> > May not be - it may be that you have a core of data in one database, and
> > that you have a number of optional additional data in a number of

> satellite

> > databases, these all have a common schema but may be produced in house,
> > or obtained from external sources.

>
> Very true, I just think in the majority of cases (99% of all the occasions
> that I've seen it) that using more than one database is an indication of a
> poorly designed data structure.
>
> Paulus
>
>