MySQL

what to do with this .SQL script?

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Feb 2005

Posts: 3

Reputation: kubota is an unknown quantity at this point

Solved Threads: 0

kubota

Offline

Newbie Poster

what to do with this .SQL script?

Feb 9th, 2005

hi, in order to install my php gallery, i have to "Run the photos.sql script in your MySQL database" what does this mean? i know i have mysql, as i have a phpBB2 forum running. but how do i do this? thanks

•

Join Date: Feb 2005

Posts: 181

Reputation: Paul.Esson is an unknown quantity at this point

Solved Threads: 10

Paul.Esson Paul.Esson is offline

Offline

Junior Poster

Re: what to do with this .SQL script?

Feb 11th, 2005

somthing like

Help with Code Tags

MySQL Syntax (Toggle Plain Text)

 
mysql < photos.sql

should do the trick

•

Join Date: Feb 2005

Posts: 3

Reputation: kubota is an unknown quantity at this point

Solved Threads: 0

kubota

Offline

Newbie Poster

Re: what to do with this .SQL script?

Feb 11th, 2005

??? but i wanted to know how to add it to my MySQL database :O

•

Join Date: Feb 2005

Posts: 181

Reputation: Paul.Esson is an unknown quantity at this point

Solved Threads: 10

Paul.Esson Paul.Esson is offline

Offline

Junior Poster

Re: what to do with this .SQL script?

Feb 14th, 2005

mysql mydatabasesname < photos.sql

•

Join Date: Feb 2005

Posts: 3

Reputation: kubota is an unknown quantity at this point

Solved Threads: 0

kubota

Offline

Newbie Poster

Re: what to do with this .SQL script?

Feb 14th, 2005

•

Originally Posted by Paul.Esson

mysql mydatabasesname < photos.sql

errrr.....have you actually read my question, your an idiot or what, if ya not gonna help, fade away.......

•

Join Date: Feb 2005

Posts: 181

Reputation: Paul.Esson is an unknown quantity at this point

Solved Threads: 10

Paul.Esson Paul.Esson is offline

Offline

Junior Poster

Re: what to do with this .SQL script?

Feb 15th, 2005

Well hmm, Yes I did, LETS say i have a database called test !! and a mysql script that looks like such

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
[root@Kat root]# cat pont.sql
#DROP TABLE `test`
#CREATE TABLE test(nick VARCHAR(30), about VARCHAR(30));
 
INSERT INTO test () VALUES ("Paul.Esson" , "Trying to be nice" );
INSERT INTO test () VALUES ("kubota" , "Idiot");
SELECT * FROM test
[root@Kat root]# cat pont.sql
#DROP TABLE `test`
#CREATE TABLE test(nick VARCHAR(30), about VARCHAR(30));

INSERT INTO test () VALUES ("Paul.Esson" , "Trying to be nice" );
INSERT INTO test () VALUES ("kubota" , "Idiot");
SELECT * FROM test

because I do, Now I wish to run this script

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
[root@Kat root]# mysql test < pont.sql
nick    about
Paul.Esson      Trying to be nice
kubota  Idiot
Paul.Esson      Trying to be nice
kubota  Idiot
Paul.Esson      Trying to be nice
kubota  Idiot
[root@Kat root]#
[root@Kat root]# mysql test < pont.sql
nick    about
Paul.Esson      Trying to be nice
kubota  Idiot
Paul.Esson      Trying to be nice
kubota  Idiot
Paul.Esson      Trying to be nice
kubota  Idiot
[root@Kat root]#

It works for me

You might try reading the man pages ?

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
[root@Kat root]# man mysql | tail -n 20 | head -n 5
EXAMPLE
       You can also READ a backup dump file back INTO MySQL with:
 
       mysql  database < backup-file.sql
[root@Kat root]# man mysql | tail -n 20 | head -n 5
EXAMPLE
       You can also read a backup dump file back into MySQL with:

       mysql  database < backup-file.sql

So basicly what you need to do is open up some kinda console
start > run > cmd

in windows

then you need to make certain that mysql is in your path, prolly easyest to change to the mySQL dir, then you type

mysql theDatabaseName < C:\path\to\the\file\photowhatever.sql

and pray it should hopfully work without a hitch.

•

Join Date: Nov 2003

Posts: 360

Reputation: Gary King will become famous soon enough

Solved Threads: 5

Gary King

Offline

PHP/vBulletin Guru

Re: what to do with this .SQL script?

Feb 21st, 2005

Do you have phpMyAdmin installed? If not, then INSTALL IT. It's the best way to work with MySQL for dummies (even experts use it, very easy to use.) I'm sure you already have it installed on your webhost, though. Then just import the file in phpMyAdmin.

Gary King
http://www.kinggary.com/
http://www.linkedin.com/in/garyking