Re: [Postfixadmin-devel] upgrade problem
Brought to you by:
christian_boltz,
gingerdog
From: David G. <da...@co...> - 2009-01-11 15:28:13
|
> Cool!! I will give you what ever you want. Just tell me the commands to run. > I am a mysql novice. I know how to dump the whole db and restore it but I do > not know how to dump the schema. I can give you information from both old > and > new as the old one is still in production and the new one is obviously semi > b0rked. > > FWIW the old db is running on mysql-4.1.22-2.el4 the new one is running on > mysql-5.0.45-7.el5. I do not know if that matters or not but I thought I > would > include it in case it does. Try : mysqldump -u whatever -ppassword postfix > whatever.sql gzip whatever.sql then attach whatever.sql.gz to me. Change 'postfix' to the name of your database. Note the above include all data, if you wish to exclude the data, use the --no-data option. Thanks David. -- David Goodwin [ david at codepoets dot co dot uk ] [ http://www.codepoets.co.uk ] |