Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Battlefield 3 Stats Module

User Box

Anonymous

38.107.179.216

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ?This sh...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriousl...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - Inserting sql through the use of phpmyadmin

Inserting sql through the use of phpmyadmin

6 Replies / 3106 Views


www.clanthemes.com Forum Index » General Topics	View previous topic :: View next topic

Amazon.co.uk Widgets

Jake302
Reputation: 461.8
Local time: 4:25 AM

Rocket Noob

0.01 posts per day
Medals: 0

Joined: Apr 29, 2007
Last Visit: 09 May 2007
Posts: 21
Points: 100

Inserting sql through the use of phpmyadmin Posted: Sat May 05, 2007 1:30 pm

This may sound stupid... But how do you create tables from an SQL file. I was able to do it once before but only because it was in a .php file and it had step by step instructions. But now i have a .SQL file and I have no idea what to do with it. Can I get some help?

floppy
Reputation: 2087.2
votes: 22
Local time: 4:25 AM
Location: Jackson Mississippi

Site Admin

1.73 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Posted: Sat May 05, 2007 1:37 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

You can do this two ways, but you need to do it from phpmyadmin.

In cpanel find mysql databases - on the databases page at the very bottom is a link to phpmyadmin.

Once inside phpmyadmin you can click the import tab and browse to your .sql file.

Or you can click the sql tab and copy the text from .sql file into the input area, then hit go.

Hope that helps

Phpnuke Downloads | VMaxxRx Male Enhancement

Jake302
Reputation: 461.8
Local time: 4:25 AM

Rocket Noob

0.01 posts per day
Medals: 0

Joined: Apr 29, 2007
Last Visit: 09 May 2007
Posts: 21
Points: 100

Posted: Sat May 05, 2007 1:39 pm

Well... i've never even heard of cpanel, so for the other way,

where is the input area?

topjob
Reputation: 522.4
votes: 2
Local time: 2:25 AM

0.05 posts per day
Medals: 0

Scripts/Coder

Joined: Apr 05, 2007
Last Visit: 13 Mar 2010
Posts: 89
Points: 9264

Posted: Sat May 05, 2007 1:53 pm

I'm not sure what type of hosting you have, but you need to have access to your database through a maintenance program. Floppy mentioned PHPMyAdmin because it is the most popular. Check with your host to find out how to access your MySql database directly.

Jake302
Reputation: 461.8
Local time: 4:25 AM

Rocket Noob

0.01 posts per day
Medals: 0

Joined: Apr 29, 2007
Last Visit: 09 May 2007
Posts: 21
Points: 100

Posted: Sat May 05, 2007 2:06 pm

After I upload the tables, thats it? everythings set up?

floppy
Reputation: 2087.2
votes: 22
Local time: 4:25 AM
Location: Jackson Mississippi

Site Admin

1.73 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Posted: Sat May 05, 2007 4:03 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

Yes as far as the .sql goes.

dare2share
Reputation: 462
Local time: 4:25 AM
Location: nottingham

Rocket Noob

0.01 posts per day
Medals: 0

Joined: Jun 05, 2007
Last Visit: 08 Oct 2007
Posts: 23
Points: 19970

is your hosting free or paid for? Posted: Sun Jun 17, 2007 10:25 am

maybe i can help a little.

to insert a .sql file first you need to go to your sites cp (control panel) you can access this by typing your web address in to your browser followed by /cpanel ie: www.yoursite.com/cpanel
then you need to login.

once in find your mysql option/link. and go
then you will have an option in there for phpmyadmin. go there
then it will list your sql databases. select the database you want to add the sql file to. ie if your running nuke then the database my be named something like _nuke. it will list all tables in that database. there will be an option to "import" click that and browse for your sql file on your computer. then just click upload. thats it.

if you like i will do it for you or email me and i will email you back my number and you can call me and i will talk you through it as you do it. but first make sure you have access to your sites control panel. if your not sure ask your host.

d2s
topnok@hotmail.co.uk

www.clanthemes.com Forum Index » General Topics

6 Replies / 3106 Views
Page 1 of 1
All times are GMT

Display posts from previous:

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work