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 <[email protected] >: > 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], 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], 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]
