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 --- Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft. https://www.avast.com/antivirus -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org