[advanced search]
Results from the most recent live auction are here.
21 members in the live chat room. Join Chat!
Register Rules & FAQ NP$ Store Active Threads Mark Forums Read
Domain Name Industry Newsletter
Go Back   NamePros.Com > Design and Development > Programming
Reload this Page Need MySQL help
User Name
Password

Old 07-04-2008, 07:57 PM   · #1
name-cloud
NamePros Member
 
Name: Pat Dryburgh
Trader Rating: (0)
Join Date: Jun 2008
Posts: 33
NP$: 0.00 (Donate)
name-cloud is an unknown quantity at this point
Need MySQL help
Hey everyone,

Today I started to develop a website using a pre-existing database (with the extension .sql). I am trying to figure out how to use this database on my website.

I have MySQL on my server, but I don't know if that's what I need.

Any help would be appreciated!


Please register or log-in into NamePros to hide ads
__________________
business: name-cloud.com
blog: patdryburgh.net

I strongly recommend MediaTemple.net for web hosting.
name-cloud is offline   Reply With Quote
Old 07-04-2008, 08:13 PM   · #2
Constantin
DNOA Member
 
Constantin's Avatar
 
Trader Rating: (63)
Join Date: Jan 2006
Posts: 1,068
NP$: 181.75 (Donate)
Constantin is a splendid one to beholdConstantin is a splendid one to beholdConstantin is a splendid one to beholdConstantin is a splendid one to beholdConstantin is a splendid one to beholdConstantin is a splendid one to beholdConstantin is a splendid one to behold
Do you have access to phpMyAdmin through your hosting interface control (Cpanel, Plesk or whatever).

If not, you can install it from www.phpmyadmin.net

Then you can use phpMyAdmin to import the sql file into your database.
Constantin is offline  
  Reply With Quote
Old 07-04-2008, 09:02 PM   · #3
name-cloud
NamePros Member
 
Name: Pat Dryburgh
Trader Rating: (0)
Join Date: Jun 2008
Posts: 33
NP$: 0.00 (Donate)
name-cloud is an unknown quantity at this point
I do have phpmyadmin, and have attempted to import the file. However, it seems there is a 10000 KB limit, and the database is about 500MB

Any ideas how to fix that?
__________________
business: name-cloud.com
blog: patdryburgh.net

I strongly recommend MediaTemple.net for web hosting.
name-cloud is offline   Reply With Quote
Old 07-05-2008, 03:22 AM   · #4
Peter
NamePros Staff
 
Peter's Avatar
 
Name: Peter
Location: Scotland
Trader Rating: (45)
Join Date: Nov 2003
Posts: 4,172
NP$: 2035.15 (Donate)
Peter has much to be proud ofPeter has much to be proud ofPeter has much to be proud ofPeter has much to be proud ofPeter has much to be proud ofPeter has much to be proud ofPeter has much to be proud ofPeter has much to be proud ofPeter has much to be proud ofPeter has much to be proud of
Child Abuse Save The Children Save The Children
name-cloud to upload a file that large you would be much better off importing while in SSH. Do you have SSH access?
Peter is offline   Reply With Quote
Old 07-05-2008, 08:32 AM   · #5
Bruce_KD
NamePros Member
 
Trader Rating: (1)
Join Date: Sep 2006
Posts: 78
NP$: 100.00 (Donate)
Bruce_KD will become famous soon enoughBruce_KD will become famous soon enough
The version of phpMyAdmin that I'm currently using (2.11.6) has an option to kill the upload right before it times out.
It also gives you the number of queries to skip.

I have never used this, but I'm assuming you could upload the file with this option ("Partial Import"). When it reaches the limit, it would tell you it executed XXX queries.
Do another partial import, this time starting by skipping the XXX queries.
Obviously, repeat until the file has been completely uploaded.


Bruce
Bruce_KD is offline   Reply With Quote
Old 07-05-2008, 09:33 AM   · #6
name-cloud
NamePros Member
 
Name: Pat Dryburgh
Trader Rating: (0)
Join Date: Jun 2008
Posts: 33
NP$: 0.00 (Donate)
name-cloud is an unknown quantity at this point
Originally Posted by peter@flexiwebhost
name-cloud to upload a file that large you would be much better off importing while in SSH. Do you have SSH access?



I am not sure... I'm fairly new to this side of web development, so I'm not sure what "SSH" is.

Originally Posted by Bruce_KD
The version of phpMyAdmin that I'm currently using (2.11.6) has an option to kill the upload right before it times out.
It also gives you the number of queries to skip.

I have never used this, but I'm assuming you could upload the file with this option ("Partial Import"). When it reaches the limit, it would tell you it executed XXX queries.
Do another partial import, this time starting by skipping the XXX queries.
Obviously, repeat until the file has been completely uploaded.


Bruce



I have 2.11.0, and it does have a section that says

"Partial import
Allow interrupt of import in case script detects it is close to time limit. This might be good way to import large files, however it can break transactions."

Is this where I do that? I don't, however, see a place to kill the import when it's going...

Thanks everyone!
__________________
business: name-cloud.com
blog: patdryburgh.net

I strongly recommend MediaTemple.net for web hosting.
name-cloud is offline   Reply With Quote
Old 07-05-2008, 10:38 AM   · #7
Chicken
I came first!
 
Chicken's Avatar
 
Location: Canada
Trader Rating: (27)
Join Date: Oct 2005
Posts: 885
NP$: 17.00 (Donate)
Chicken is a name known to allChicken is a name known to allChicken is a name known to allChicken is a name known to allChicken is a name known to allChicken is a name known to all
Save The Children Save The Children Save The Children Save The Children
Originally Posted by name-cloud
I am not sure... I'm fairly new to this side of web development, so I'm not sure what "SSH" is.



I have 2.11.0, and it does have a section that says

"Partial import
Allow interrupt of import in case script detects it is close to time limit. This might be good way to import large files, however it can break transactions."

Is this where I do that? I don't, however, see a place to kill the import when it's going...

Thanks everyone!


You could try using BigDump
http://www.ozerov.de/bigdump.php

You just edit the file with your database details and then upload the database file to your host. Then navigate to the script and hit import beside the database file.
__________________
█ AC/DC Talk - Talk about one of the greatest bands today.
█ ChickenSMS - Let your visitors send free text messages.
█ Blow Up Your Video - Read all about AC/DC and its members.
█ No Cry Server - For gaming server admins.
Chicken is offline   Reply With Quote
Old 07-06-2008, 07:59 AM   · #8
nasaboy007
NamePros Regular
 
Location: mysitememberships.com
Trader Rating: (32)
Join Date: Jul 2005
Posts: 862
NP$: 4244.90 (Donate)
nasaboy007 is a splendid one to beholdnasaboy007 is a splendid one to beholdnasaboy007 is a splendid one to beholdnasaboy007 is a splendid one to beholdnasaboy007 is a splendid one to beholdnasaboy007 is a splendid one to beholdnasaboy007 is a splendid one to behold
try reading through http://rikahsdesign.blogspot.com/20...l-files-to.html

i've used mysql tools to upload a rather large sql file and it worked pretty well. i also tried bigdump and that seemed to work.
__________________
nasaboy007 is online now   Reply With Quote
Old 07-07-2008, 10:47 AM   · #9
gezzle
NamePros Member
 
Trader Rating: (4)
Join Date: Jun 2008
Posts: 91
NP$: 79.00 (Donate)
gezzle is an unknown quantity at this point
you can try MySQL administrator :
http://www.mysql.com/products/tools/administrator/

If you have a Linux server high probability you can SSH using Putty.

If you manage SSH to your server issue this command :
mysql -u username -p yourdatabase < yourfile.sql

It will prompt your password and then import the sql in the youdatabase database..
gezzle is offline   Reply With Quote
Old 07-07-2008, 02:07 PM   · #10
rafaelrls
NamePros Member
 
rafaelrls's Avatar
 
Location: me = new (live(in.paradise())
Trader Rating: (-1)
Join Date: Jan 2008
Posts: 154
NP$: 0.00 (Donate)
rafaelrls is an unknown quantity at this point
man, you can upload the .sql file to your server and run the import command from phpmyadmin from there, so there will not be an error about timeout of the upload from phpmyadmin, because the file will be local to your server.
rafaelrls is offline   Reply With Quote
Reply

NamePros is a revenue sharing forum.
« a little XML help? | Adding chatbox »

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


Site Sponsors
Hunting Moon free webhosting EscrowDNS
Advertise your business at NamePros
All times are GMT -7. The time now is 09:22 PM.

Advertise At NamePros - Contact Us - NamePros.Com - Archive -Privacy Statement -Top

Powered by: vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0