database recovery :: Archived

DJ Maze · Posted: Wed Jun 08, 2005 4:25 am Post subject: Re: database recovery

Code::

ENGINE=MyISAM DEFAULT CHARSET=latin1

Is a special MySQL 4.x command and will not work on every system.
Removing those crappy phpmyadmin parts will make it more versatile.

It's best to use the Dragonfly CMS DB backup utility since it will take those issues and others (like FULLTEXT) into account

tank · Posted: Wed Jun 08, 2005 12:52 pm Post subject: Re: database recovery

If you don't get it I'll help you out tonight.

ilamos · Nice poster Offline Joined: Dec 27, 2004 Posts: 82

Still no luck. I would appreciate any help. I posted my contact info twice on the previous page so let me know when you want to help me.

tank · Posted: Thu Jun 09, 2005 8:17 pm Post subject: Re: database recovery

Got busy last night. Should be able to help tonight. I'll contact you.

RECON

How to restore the whole database backup.
Importing the database if its big one on another server for example or if needed to restore the latest backup?
I know there must be some skripts around but i cant found any of them to import simple and easy my database file to the mysql.
Who know some solutions Confused

I think i dont have ssh. There must be some scripts but i coudnt found any restore script.

Mmany thanks.

Head-e · Silver Supporter Offline Joined: Apr 20, 2004 Posts: 937

admin.php?op=database
under Import SQL File

or login to your phpmyadmin and load the .sql backup

RECON · Posted: Fri Sep 09, 2005 11:22 am Post subject: Re: database recovery

Thanks i was try that it break or give me a error out db file is over 20 mb. Is there a limit?

Head-e · Silver Supporter Offline Joined: Apr 20, 2004 Posts: 937

i think it defaults to the limit set in php.ini do a forum search, dj posted a solution for uploading large database files

Bloo · Newbie Offline Joined: Mar 02, 2007 Posts: 2

ilamos wrote:

Just forget I give up. I'll just start over new.

Since this user didn't seem to get this answered and I ran into and solved this problem last night I thought I'd help the community with trudging up this old post in case someone happens to run across it again.

My issue was nearly identical. I was astonished to discover my new host was running MySQL 4.0.x which does not recognize the "DEFAULT CHARSET" syntax. I exported from a host that was running MySQL 4.1.x

Simply remove "DEFAULT CHARSET=latin1" from your flat file entirely and the load will go fine on a 4.0.x MySQL server.

RECON wrote:

Thanks i was try that it break or give me a error out db file is over 20 mb. Is there a limit?

Here's an absolute must have for solving big db uploads without having SSH access to your host that I found linked elsewhere on this site. It's a simple small script that does exactly what you need as phpMyAdmin has a 2mb limit on upload file size.
BigDump

Phoenix · Posted: Fri Mar 02, 2007 7:36 pm Post subject: Re: database recovery

Bigdump has been referenced very many times in these forums for many people with size limitations - it is an excellent tool, especially for very, very large databases Smile

Bloo · Newbie Offline Joined: Mar 02, 2007 Posts: 2

Phoenix wrote:

Bigdump has been referenced very many times in these forums for many people with size limitations - it is an excellent tool, especially for very, very large databases Smile

Someone should tell those folks over there working on the phpMyAdmin project that they need link up with Alexey Ozerov @ ozerov.de and get his awesome script added. It's been around a long time and everyone using phpMyAdmin ends up eventually picking it up. LOL