Am 12.01.2017 um 11:03 schrieb Admin Beckspaced:
On 12.01.2017 09:07, Roger Oberholtzer wrote:
I have a web site that used a MySQL database for it's data. This has been running on openSUSE 12.3. I am moving it to Tumbleweed. I would prefer, if possible, just to copy the existing MySQL stuff (var/lib/mysql) to the new server and run MySQL. I am hoping to eliminate this web site, so I don't really want to invest too much time. So I wonder, can I just:
1. Copy /var/lib/mysql from the old to the new server 2. Install and enable mysql-community-server
I think that looks optimistic.
depending on the different MySQL versions a copy & paste could work?
to make things sure a mysqldump and later import would be the preferred way:
mysqldump -uUser -pPass --opt somedatabase > /tmp/somedatabase.sql mysql -uUser -pPass somedatabase < /tmp/somedatabase.sql
best of luck ;) Becki
But mysqldump does not copy users, passwords and permissions. I would try to copy /var/lib/mysql and check changelogs and messages if you have to run a upgrade procedure. If you really have to export/import the data, then you can use tools like mysqluserclone to copy the mysql users: http://dev.mysql.com/doc/mysql-utilities/1.6/en/mysqluserclone.html