Need MySQL help

[name-cloud]

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]

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]

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]

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]

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]

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.

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]

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]

try reading through http://rikahsdesign.blogspot.com/2007/10/how-do-i-upload-large-sql-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]

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]

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.