Export and Import of database errors, please advise.

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 402,617 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,273 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 981 | Replies: 19

Previous Post in Thread

Next Post in Thread

•

Join Date: Feb 2008

Posts: 35

Reputation: Kraai is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

Kraai

Offline

Light Poster

Re: Export and Import of database errors, please advise.

#11

May 15th, 2008

I think you hit the nail dead center here. The data was downloaded via export function of phpmyadmin, and it seems now that the download stream may have been interupted or dipped or something, and there is some more data that is missing.

In the meantime, I re-exported the database, in gzip format, and this took only 2 seconds, which make me think that the zipfile may not even have something in it. On my pc, it does not want to open the gzip file, it tells me it may be corrupt.

However, I then tried to import the gzip to the server, and got the "not enough" memory error in phpmyadmin:

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 10201461 bytes) in /usr/share/phpmyadmin/export.php on line 81 

What does all this mean?

Thank you so much for your support and patience with me, and your proposal to view the data. If all else fails, I don't have a problem if you view the data.

I left my hotdog somewhere, If you find it, feed it please, or better feed yourself!!
Webhostig and ISP Solutions in ZA