Transplanting CMSMS?

[BrianB]

I'm new to the whole CMS thing, and to MySQL as well, so I'm having trouble figuring out what CMSMS keeps in a MySQL database and what it keeps as "real" files...

So, to move an existing, customized CMSMS install from one computer to another, is it enough to just bundle up the cmsms directory and copy that over, or do I have to do something with the SQL side?

I suspect I am - more advice would be appreciated!

If someone can also point me to a good intro to MySQL page, that would also be appreciated - the mysql man pages are about as useful as most man pages ever are, ie not very...

Thanks!

[Ted]

Take a look at these links...

http://forum.cmsmadesimple.org/index.ph ... 661.0.html
http://www.rlrouse.com/backup-restore-mysql.html
http://www.devshed.com/c/a/MySQL/Backin ... -Database/

[BrianB]

Reviving an old post here...
brian@warbard:~$ mysqldump -u cms_user -p cms_pass cms > vlug_test_cms.sql
Enter password:
mysqldump: Got error: 1045: Access denied for user: 'cms_user@localhost' (Using password: YES) when trying to connect

AFAIK I used the defaults suggested in http://wiki.cmsmadesimple.org/en:instal ... ickinstall, but MySQL doesn't seem to think so...

I tried "sudo mysqldump....etc" as well, but that gives the same error. (I run Ubuntu, so sudo instead of root is the order of the day)

I've been trying to follow http://www.rlrouse.com/backup-restore-mysql.html

Am I doing something obviously wrong, or what?

[Ted]

There should be no space between -p and cms_pass.  It's sort of a weird irregularity with mysql that you just get used to. 

[BrianB]

That's an obscure sort of bug/feature in MySQL... 

This worked nicely:
mysqldump -v -u cms_user -pcms_pass cms > vlug_test_cms.sql

Thanks!

[BrianB]

brian@vlugtest:~ ssh$ sudo mysqlimport -u cms_user -pcms_pass cms vlug_test_cms.sql
mysqlimport: Error: Access denied for user: 'cms_user@localhost' (Using password: NO), when using table: vlug_test_cms

This is on the new server; vlug_test_cms.sql is the backed up db file.

I created a (currently empty) cms MySQL DB when I installed 0.11.1 on this new machine. MySQLimport is supposed to overwrite the existing table with the "backed up" one - so what's it choking on? Another tiny typo?

Oh, and is there a good set of MySQL tutorials out there? Everything I've found so far has been incomplete or had typos...