Previous Thread
Next Thread
Print Thread
Rate Thread
#252534 06/28/2003 10:02 AM
Joined: Oct 2002
Posts: 18
Newbie
Newbie
Offline
Joined: Oct 2002
Posts: 18
I can back my database up via Infopop Threads and via a command line mysqldump.
Problem is when I try to use PhpMyAdmin, it hangs if I include the messages table in the backup. Otherwise, it works fine. Any suggestions?

Sponsored Links
Aglavalin #252535 06/28/2003 10:30 PM
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
When you say hangs? Do you get errors - or does the browser just freeze up?

Have you tried optimizing or repairing that table to see if that fixes the problem.


Daine #252536 06/30/2003 10:47 AM
Joined: Jun 2003
Posts: 1,025
Junior Member
Junior Member
Offline
Joined: Jun 2003
Posts: 1,025
How large is your posttable? Perhaps it is just taking awhile to backup. I would definately try optimizing and/or repairing the table as Josh suggested.

Daine #252537 07/01/2003 10:53 PM
Joined: Oct 2002
Posts: 18
Newbie
Newbie
Offline
Joined: Oct 2002
Posts: 18
It times out and I get a page not found error.

BrokenToy #252538 07/02/2003 12:48 AM
Joined: Oct 2002
Posts: 18
Newbie
Newbie
Offline
Joined: Oct 2002
Posts: 18
A few thousand posts. I optimized and repaired. I'll keep trying.

Sponsored Links
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
This won't work if you sserver is in safe mode. But in the config file for phpMyadmin there is a max execuation time. Usually this is at 300 by default. Set this to 0 to turn the limit off. However if your server is in safe mode - this won't have any effect. But it's worth a try.

Daine #252540 07/14/2003 10:36 AM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
2.52 is supposed to do a better job of exporting large tables, let's cross our fingers as I've had the same problem


- Allen wavey
- What Drives You?
Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
I recently upgraded from 2.5.0 to 2.5.1, and it looks like the capability to export to a local file was added, by specifying a value for $cfg['SaveDir'] in config.inc.php.


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)