Backup/Restore MySQL Database...

[gtr_rider]

My old host for a site I have is closing and I had a forum running on their database. Their software sucked goatnads ( MySQL 3.23.49 ) and its not the same as the one i have now ( MySQL 3.23.36 ), so i got the dump from the previous, and im trying to dump it into the new host but its giving an error.. Something to this effect..

This is all related to YaBBSe 1.4.0

Code Select Expand

-- MySQL dump 8.21
--
-- Host: *************  Database: **********
---------------------------------------------------------
-- Server version   3.23.49

--
-- Table structure for table 'phpbb_auth_access'
--

CREATE TABLE phpbb_auth_access (
  group_id mediumint(8) NOT NULL default '0',
  forum_id smallint(5) unsigned NOT NULL default '0',
  auth_view tinyint(1) NOT NULL default '0',
  auth_read tinyint(1) NOT NULL default '0',
  auth_post tinyint(1) NOT NULL default '0',
  auth_reply tinyint(1) NOT NULL default '0',
  auth_edit tinyint(1) NOT NULL default '0',
  auth_delete tinyint(1) NOT NULL default '0',
  auth_sticky tinyint(1) NOT NULL default '0',
  auth_announce tinyint(1) NOT NULL default '0',
  auth_vote tinyint(1) NOT NULL default '0',
  auth_pollcreate tinyint(1) NOT NULL default '0',
  auth_attachments tinyint(1) NOT NULL default '0',
  auth_mod tinyint(1) NOT NULL default '0',
  KEY group_id (group_id),
  KEY forum_id (forum_id)
) TYPE=MyISAM

MySQL said:


You have an error in your SQL syntax near '---------------------------------------------------------
-- Server version   3.23' at line 4

[Jeff Lewis]

Their software sucked goatnads ( MySQL 3.23.49 ) and its not the same as the one i have now ( MySQL 3.23.36 )

Their version is newer than yours, how does it suck gonads?

Anyway, there have been several posts about backing things up lately...someone will post a link if you don't find it first

[PioneeR]

I used to be able to backup fine... until my lovely hosts introducted a limit of 30 seconds for execution of any scripts... doh!!

[gtr_rider]

I was able to get it to work, yes I noticed that the first database was newer then mine

Here what happened...

The two softwares where reading different command lines, so I had to remove the slashes( -- ) before ever command since those arent compatible with the lexical parser.. just removed them

[Ben_S]

I used to be able to backup fine... until my lovely hosts introducted a limit of 30 seconds for execution of any scripts... doh!!

Does your host run in safe mode? If not you can probably overide the time limit

[PioneeR]

No.. its not in safe mode... sooooooooo how would i be able to override this stupid 30 second limit??  

[Jeff Lewis]

Add this to the top of the script:

set_time_limit (0);

[Ben_S]

Or add this to your .htaccess file

Code Select Expand

php_value max_execution_time 120
Where 120 is a number of seconds and can be whatever you like

[PioneeR]

Tried both the above methods... still times out on me.. probs me doing something wrong!!

[PioneeR]

I assume the server I am isnt running safe mode because I installed yabb from the install script.

I have tried both the above methods to try and extend the 30 second limit.. still times out though.

Any more ideas??