Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

cannot export database


seanpaul

Recommended Posts

Posted

Hi All,

 

When I go to export my database from phpmyadmin I get page cannot be displayed after I hit the go button.

 

I'm totally stumped anyone any ideas

 

thanks

Posted

Ok, I think this is due to having installed the user tracking mod, the user tracking table in the database is a massive 3.5mb, I guess this is causing the problem....

 

This still causes me a problem as I want to keep that info but am unable to export it.

 

Any ideas? (please)

Posted

dont mind me, I'l just keep talking to myself.... :lol:

 

I had to empty that section of the database, I suppose the only way to store the user tracking info would be to export on a daily basis.

Posted

You might want to give SQLyog a look. You run it from your local system but can access your server's databases (as long as your host has remote access enabled).

 

It does not suffer from the timeout issues that PHPMyAdmin does.

 

The other alternative is to use mysqldump from a secure shell prompt at your server.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Posted

Thanks Daemonj will look into the SQLyog and the dump via secure shell is a good idea, didnt think of that.

 

thanks again

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...