SQL database IMPORT

[rj]

I am using SQL at GODADDY.
My assumption is that the SQL pages are the same at any server.
No problem dumping (export).
No problem find/replace in my new editor NOTETAB.
But could not find where to IMPORT the .sql file.
Finally I hit a SQL tab in a sidebar and a window popped up saying
IMPORT FILES (max 2,046KB)
The DB is 80megs.

So I called GODADDY and they said do it a file at a time.
NO WAY.
So they said upload your new .sql file to your root and we will put it in for you.

With all the blogs backing up their DBs there must be some easy way of IMPORTING the entire SQL if something goes wrong. Isnt there?

THANX

RJ

[garvinhicking]

Hi!

A custom installed phpMyAdmin can import uploaded SQL dumps. However it is also memory restricted, I think.

Godaddy is right, you would need to split up the dump in multiple files. HTTP isn't meant for importing thise large files. In contract to exportting, all imported data needstobe loaded/parsed somehow,so that's more resource intensive.

Regards,
Garvin

[rj]

Hmmm... So to back up by using the big .sql file I would have to break it up into 40 pieces... 80megs 2 meg limit. That would seem harder to do than by serendipity_files

When I see the SQL page, all your files are listed on the left with check boxes. So rather than do an entire dump, could I select all the boxes and save them as separate files as my backup process?
Then if trouble came I could upload them one at a time.

Did I make sense?

RJ

So sometime in the next 24 hours GODADDY is going to import my /serendipity/ LESS db.
BTW, there were 5004 of them. Does that sound right?

I wonder what will happen?
I suppose I wont really know until I RENAME the old /serendipity directory the external links are now still using...

Or it will explode or something!

[garvinhicking]

Hi!

The 2mb limit is quite small, that comesfrom your provider. Usually the upload limit is often set to 8MB, so that would mean only 10 files.

However, by using the phpMyAdmin file import utility, you should be able to import larger files, have you tried that?

When I see the SQL page, all your files are listed on the left with check boxes. So rather than do an entire dump, could I select all the boxes and save them as separate files as my backup process?
Then if trouble came I could upload them one at a time.

You mean tables, not files, right? Yes, you could export them one by one!

I wonder what will happen?

I'm excited, too *g*

Good luck,
Garvin

[rj]

What do the millions of blogs do when they back up every night and then once in awhile it goes wrong and they have to put their backup back up?

It is a matter of the version of myadminphp program?
Or do millions of blogs manually downlaod all their files every night?
I suspect I am missing something.
But.
The answer from GODADDY was fast and hard.
Send it, we will do it.

[garvinhicking]

Hi!

What do the millions of blogs do when they back up every night and then once in awhile it goes wrong and they have to put their backup back up?

They use the method I outlined above, or their provider (who usually processes/creates backups) imports them.

It is a matter of the version of myadminphp program?

It might, depending on the version you are using. phpMyAdmin, like s9y, constantly evolves.

Best regards,
Garvin