Import large db script (useful for SQUIRTERS!)

[LazyHippy]

Found this nice little script, imports large sql databases with ease!

BigDump: The Staggered MySQL Dump Importer

Seems to have worked perfectly with the 600Mb lyric db.

Ok, it's prob easy to write isn't it? I don't know - it was easy to find!

 

[maxor]

If you've got shell access there's always the mysql command line!

$> mysql -ulogin -ppassword database_name < database_back.sql

 

[Grant29]

Yep, you'll die trying to import something really large via phpmyadmin or something. Import it at the shell command level so you don't have to worry about size limits. Most server configurations allow from 2Mb to 50Mb attachments so with the above method you'd have to split the .SQL file multiple times (plus have to wait for each chunk to upload).

 

[CLKeenan]

yah, I just use shell commands after uploading the .sql file to my server

 

[LazyHippy]

Cheers for that guys. I've just got shared hosting accounts though - no shell access. Grant - when are you saying you'd have to split the file to upload it? You don't need to split it with this script.

 

[sleepylee]

No - no splitting required with shell command.

I think Grant's reference to "attachment" points towards the maximum file upload sizes in phpMyAdmin or similar - this is just the problem that BigDump tries to resolve (I believe, from a quick glance).

 

[wrstroud]

Thanks LazyHippy, +rep

I was trying to import the squirt restaurant database the other day and wanted to die.

 

[ScottDaMan]

BTW, zip the file up in normal compression for much quicker uploading via FTP. Then use cpanel's file manager to decompress it. Or if you are using shell, unzip filename.zip works.

Since sql files are just a shitload of text, zipping will reduce your upload wait time by about two thirds.

This is especially useful on 500+MB files

 

[trigatch4]

What would you say about injecting lines of the DB as seperate WP posts?

 

[mydm]

I have been using the command line to import .sql databases because it works so much better. I'm still a newbie, and I have AMP on a windows laptop, so I use the mysql command line client. I'll try the script for one database I have.

thanks

 

[Mike]

Nice seocracy! Too bad Godaddy are such fucks and don't allow remote connections.

I'm really starting to hate those bastards.

 

[maxor]

Nice seocracy! Too bad Godaddy are such fucks and don't allow remote connections.

I'm really starting to hate those bastards.

I would guess that a lot of hosts don't allow remote MySQL connections.

 

[lazyleo]

Thats for your tips guys

 

[trigatch4]

Anyone that can point to a tutorial on using a huge database to import into wordpress. For example, I want the entire database to be under a specific category on an existing wordpress blog.

I'm the Hellen Keller of programming.

 

[mydm]

Heidi SQL!

Heidi SQL!

Heidi SQL!

For gods sake! Use Heidi SQL!

It lets you connect to your Mysql server and interact with your DB in real time all in a nice GUI.

and its open source.

Thanks seocracy. I just installed it and it looks great. Since I'm working locally from my laptop I had no trouble connecting.

One qn, how does Heidi SQL compare to phpMyAdmin?? Is the functionality pretty much the same? I've been told that phpMyAdmin is the golden standard , but if I'm not missing anything by not having it then I won't have to worry about installing it.

So far I like Heidi lots! :rasta:

 

[LazyHippy]

Heidi SQL!

Heidi SQL!

Heidi SQL!

For gods sake! Use Heidi SQL!

It lets you connect to your Mysql server and interact with your DB in real time all in a nice GUI.

and its open source.

Great stuff!! Cheers