Need MySQL help

name-cloud · 07-04-2008, 07:57 PM

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!

Constantin · 07-04-2008, 08:13 PM

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.

name-cloud · 07-04-2008, 09:02 PM

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?

Peter · 07-05-2008, 03:22 AM

name-cloud to upload a file that large you would be much better off importing while in SSH. Do you have SSH access?

Bruce_KD · 07-05-2008, 08:32 AM

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

name-cloud · 07-05-2008, 09:33 AM

Quote:

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.

Quote:

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!

Chicken · 07-05-2008, 10:38 AM

Quote:

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.

nasaboy007 · 07-06-2008, 07:59 AM

try reading through http://rikahsdesign.blogspot.com/200...-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.

gezzle · 07-07-2008, 10:47 AM

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..

rafaelrls · 07-07-2008, 02:07 PM

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.

07-04-2008, 07:57 PM	#1 (permalink)
name-cloud NamePros Member Join Date: Jun 2008 Posts: 33 0.00 NP$ (Donate)	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! __________________ business: name-cloud.com blog: patdryburgh.net I strongly recommend MediaTemple.net for web hosting.

07-04-2008, 08:13 PM	#2 (permalink)
Constantin Senior Member Join Date: Jan 2006 Posts: 1,081 269.00 NP$ (Donate)	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. __________________ ZileDeNastere.ro ProBazar.com - Cumparare si vanzare - nume de domenii PokerGuides.net - your all-inclusive poker resource

07-04-2008, 09:02 PM	#3 (permalink)
name-cloud NamePros Member Join Date: Jun 2008 Posts: 33 0.00 NP$ (Donate)	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.

07-05-2008, 03:22 AM	#4 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	name-cloud to upload a file that large you would be much better off importing while in SSH. Do you have SSH access? __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

07-05-2008, 08:32 AM	#5 (permalink)
Bruce_KD NamePros Member Join Date: Sep 2006 Posts: 87 100.00 NP$ (Donate)	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 __________________ Need a CAPTCHA? www.KingdomsDivided.com

07-06-2008, 07:59 AM	#8 (permalink)
nasaboy007 Senior Member Join Date: Jul 2005 Location: NJ Posts: 1,112 1,454.30 NP$ (Donate)	try reading through http://rikahsdesign.blogspot.com/200...-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. __________________ Hacksar.com - Your source for random computer tips and tricks! MySiteMemberships.com - Keep track of your site registration information! Like my post? Rep is appreciated!

07-07-2008, 10:47 AM	#9 (permalink)
gezzle NamePros Member Join Date: Jun 2008 Posts: 94 14.35 NP$ (Donate)	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..

07-07-2008, 02:07 PM	#10 (permalink)
rafaelrls NamePros Member Join Date: Jan 2008 Location: me = new (live(in.paradise()) Posts: 155 0.00 NP$ (Donate)	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. __________________ portuguese portal de noticias opiniaoweb\| generalities: new and used cars\|portuguese opiniaoweb concursos\|PharmaKnow \|wonderings of a web geek\|portuguese opiniaoweb carros\|opiniaoweb.com.br

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)