backup for old mysql from new

zodehala · #1 (**permalink**) 12-05-06, 10:06

mysql version is 5.1

How can i backup it for old one (like mysql 4.x.x or less )

healdem · #2 (**permalink**) 12-05-06, 11:06

doing a backup in MySQL administrator should work OK,also could use PhPMyAdmin

its possible you may have a problme with autonumber columns but judicous editing of the table & colum,n definiotnas should work OK

zodehala · #3 (**permalink**) 12-05-06, 23:29

Quote:

Originally Posted by healdem

doing a backup in MySQL administrator should work OK,also could use PhPMyAdmin

its possible you may have a problme with autonumber columns but judicous editing of the table & colum,n definiotnas should work OK

it is not compatibel with mysql 3.x.x

i solved to be able to be compatible with old verison in order to backup i must use following command

PHP Code:


			
mysqldump --compatible = mysql323 u zode -p123 db > /backup.sql

other wise

while restoring to old server following error occured

HTML Code:

"MySQL: Bad syntax near DEFAULT CHARACTER SET..."

Internet Services

Web Development

Digital Marketing

Consumer Tech