Hi Simon, thanks a lot, this is the info I needed. Concerning my patience, while I in a formeren life created linguistic databases of over 100 million records (which was a lot in the mid-eighties), now it's no't much more than the address records for the christmas cards... With kind regards, Jogchum Reitsma Op wo 13 dec 2023 15:44 schreef Simon Avery <Simon.Avery@atass-sports.co.uk
:
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