Hi Jogchum, You’re very patient if you’ve waited since January to repeat your question.
Generally, you would not import the mysql database from another server when restoring since its tables include much data specific to the server, not to your data and doing so could break your new server. You would just restore the specific databases that you want to. After all, you backed up databases with mysqldump, not the server. However, one thing to mention. The dump for the mysql.users table does contain the users, their passwords and grants. You may consider it useful to open this table in a text editor so you can review the users and their privileges. They’re dumped as simple SQL statements so you can cut and paste specific lines from that single table into the new mysql server to recreate them. Or just recreate the users and their grants once you’ve reimported your own databases. Simon From: Jogchum Reitsma via discuss <[email protected]> Sent: Tuesday, December 12, 2023 6:19 PM To: [email protected] Subject: [MariaDB discuss] Some questions restarting mariadb and importing the dumped databases Hi all, On 3th of januari I posted the following topic, on the previous list address, [email protected]<mailto:[email protected]>, and gave it a reminder on the 19th of januari. I did not get an answer yet, maybe also because the list address changed in the mean time. So I take the liberty to pose the question again here, hoping this time someone is able to answer the the questions asked. Would be much appreciated! (I didn't mention it in the OP, but I've read https://mariadb.com/kb/en/mariadb-dump/, which does not seem to answer the questions) regards, Jogchum Hi, 12th of October I started the topic" Maria-db refuses to start". With the help offered in the conversation following I could access my data by manually starting an older version of Mariadb. This was on the previous list address, [email protected]<mailto:[email protected]>, so I then dumped my tables with mysqldump, one by one, successfully. I also dumped the mysql table. Final advice was to purge all reminiscences of the older versions, and make a fresh start by installing the version of my OS (OpenSuse Tumbleweed). In that new environment, import the dumped data. A few questions remain: - should I, after the install process of the OS version (at the moment 10.10.2-1.1) take further actions to get a fully functioning system? - should I import the dumped "mysql" table? - if yes, should I do that before or after importing the user data? Or doesn't that matter? Again, thanks for your answers! kind regards, Jogchum
_______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
