On Thu, Jan 12, 2017 at 2:55 PM, Florian Gleixner <flo@redflo.de> wrote:
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
I copied the files (making sure they belonged to mysql). I think things started okay. It seems the web site is functioning. At least as well as it ever did. Now to phase it out. -- Roger Oberholtzer -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org