[Answered] mysql

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
EnterpriseNX01
Registered User
Posts: 48
Joined: Tue Mar 26, 2002 5:16 pm
Location: Edinburgh, United Kingdom
Contact:

[Answered] mysql

Post by EnterpriseNX01 »

how do you run a mysql file?? (*.sql)
Kylecool
Registered User
Posts: 674
Joined: Sat Feb 02, 2002 3:51 am
Location: Southern California, U.S.A! GO USA!
Contact:

Post by Kylecool »

Define RUN. Do you want to insert into a MySql database or view it on your own to edit it on your computer?

-Kyle
VACATION UNTIL june 29TH or 30th. :)
EnterpriseNX01
Registered User
Posts: 48
Joined: Tue Mar 26, 2002 5:16 pm
Location: Edinburgh, United Kingdom
Contact:

Post by EnterpriseNX01 »

Well basically, I want to install the Flags Mod, it givesme instructions to "Run Flags.sql"
Kylecool
Registered User
Posts: 674
Joined: Sat Feb 02, 2002 3:51 am
Location: Southern California, U.S.A! GO USA!
Contact:

Post by Kylecool »

Ok. Goto phpMyAdmin, if you don't have it download it from phpwizard.net. Install phpMyAdmin. Goto your database in it and there are 2 boxes to run sql queries. You can either upload that sql file or type it in manually. :) It's that simple.

-Kyle
VACATION UNTIL june 29TH or 30th. :)
Zenith
Registered User
Posts: 58
Joined: Sun Apr 14, 2002 10:02 am
Location: Canberra, Australia
Contact:

Post by Zenith »

It's even simpler....you don't need phpMyAdmin if you have shell access. At the command line....

mysql -uusername -ppassword phpBBdatabasename < sqlfilename

Z
Kail
Former Team Member
Posts: 4924
Joined: Mon Oct 22, 2001 9:57 pm
Location: Sweden
Contact:

Post by Kail »

Yes, but you'll need shell access to do that. If you don't have shell access, you must use phpMyAdmin, MySQL GUI or similar.

Jakob Persson - Style Designer, Freelance Web Designer, Usability Consultant and Developer | BLOG | PORTFOLIO
My Complete phpBB Template Design Guide
Creator of Chronicles, SpacePilot3K (updated!), Solaris, Cobalt 2.0 and JustFooty.
Image phpbb-se.com - phpBB på svenska!
Zenith
Registered User
Posts: 58
Joined: Sun Apr 14, 2002 10:02 am
Location: Canberra, Australia
Contact:

Post by Zenith »

Yah... I did say you need shell access. I find it's a lot quicker than stuffing about with a GUI sometimes.

Z
Kail
Former Team Member
Posts: 4924
Joined: Mon Oct 22, 2001 9:57 pm
Location: Sweden
Contact:

Post by Kail »

Ooops, sorry, didn't see that. I'm reading too fast I guess.

Jakob Persson - Style Designer, Freelance Web Designer, Usability Consultant and Developer | BLOG | PORTFOLIO
My Complete phpBB Template Design Guide
Creator of Chronicles, SpacePilot3K (updated!), Solaris, Cobalt 2.0 and JustFooty.
Image phpbb-se.com - phpBB på svenska!
Locked

Return to “2.0.x Support Forum”