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 <discuss@lists.mariadb.org>
Sent: Tuesday, December 12, 2023 6:19 PM
To: discuss@lists.mariadb.org
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, maria-discuss@lists.launchpad.net, 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, maria-discuss@lists.launchpad.net, 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