LinuxQuestions.org - [SOLVED] How to import old MySQL data into mariadb?

- Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)

- - How to import old MySQL data into mariadb? (https://www.linuxquestions.org/questions/linux-server-73/how-to-import-old-mysql-data-into-mariadb-4175608167/)

Quote:

Originally Posted by Habitual (Post 5725382)

I cannot tell, sorry.

Thanks anyway. I will keep bashing away until I beat it into submission. "8-)

Quote:

Originally Posted by Doug Hutcheson (Post 5725396)

I will keep bashing away until I beat it into submission.

Well, I did a fresh installation of mariadb, copied the database directories from the archive into the current /var/lib/mysql and everything immediately worked! It seems the structure of the file triplets from the archive is still understood by the latest mariadb. I took the good advice above and immediately ran a dump from the command line, which proceeded without any problems and the resulting SQL files are as expected.

Many thanks for all the help.
Kind regards,
Doug

Your file listing give me an idea, that current MariaDB uses InnoDB as default.
Read here https://dev.mysql.com/doc/refman/5.7...ge-engine.html
and maybe here https://dev.mysql.com/doc/refman/5.7...databases.html
and maybe it helps you.

Quote:

Originally Posted by jareklakman (Post 5725532)

MariaDB uses InnoDB as default

Thanks for the links jareklakman. I will read and digest after another cup of coffee, but it looks like very useful information.
Kind regards,
Doug

Quote:

Originally Posted by Habitual (Post 5725586)

inxi -Fszr -c0 | nc termbin.com 9999

Hmmm ... my Fedora 25 has neither inxi nor termbin. If I were to install them and run your command, what would it do? I gather inxi reports hardware configuration, but why termbin?

If nothing else, you have given me something to research, but it would be good if you could give me a head start in understanding it. "8-)

Kind regards,
Doug.

Quote:

Originally Posted by Doug Hutcheson (Post 5725885)

Using

Code:

inxi -Fsz -c0 | nc termbin.com 9999

produces this http://termbin.com/805w
termbin is a site, not a program.
inxi is the program. Where it is on your distro? IDK sorry.
Details on how, why, and what for termbin are at termbin.com. (not my site)
Links are easier on the board as some new members have trouble with [code][/code] markup(s) on textual output.
So asking them to paste a link is easier than trying to implement a "how to use [code][/code] markups" on vBulletin software.

Quote:

Originally Posted by Habitual (Post 5726009)

Using

Code:

inxi -Fsz -c0 | nc termbin.com 9999

produces this http://termbin.com/805w
termbin is a site, not a program.
inxi is the program. Where it is on your distro?

The light daws - somewhat. "8-)

I found inxi on my system - I must have mistyped the name before.

The output to my terminal, without piping to termbin, is as follows, so what is termbin needed for? "8-/

Code:

System:    Host: womble Kernel: 4.11.4-200.fc25.x86_64 x86_64 (64 bit) Desktop: N/A

          Distro: Fedora release 25 (Twenty Five)

Machine:  Device: laptop System: Acer product: Aspire E1-571 v: V2.15

          Mobo: Acer model: EA50_HC_CR v: Type2 - Board Version UEFI: Insyde v: V2.15 date: 03/11/2013

Battery    BAT1: charge: 37.4 Wh 100.0% condition: 37.4/44.0 Wh (85%)

CPU:      Quad core Intel Core i7-3632QM (-HT-MCP-) cache: 6144 KB 

          clock speeds: max: 3200 MHz 1: 1200 MHz 2: 1417 MHz 3: 1203 MHz 4: 1366 MHz 5: 1201 MHz 6: 1570 MHz

          7: 1207 MHz 8: 1293 MHz

Graphics:  Card: Intel 3rd Gen Core processor Graphics Controller

          Display Server: X.org 1.19.3 driver: N/A tty size: 172x44 Advanced Data: N/A for root

Audio:    Card Intel 7 Series/C216 Family High Definition Audio Controller driver: snd_hda_intel

          Sound: Advanced Linux Sound Architecture v: k4.11.4-200.fc25.x86_64

Network:  Card-1: Broadcom Limited NetLink BCM57785 Gigabit Ethernet PCIe driver: tg3

          IF: enp2s0f0 state: down mac: <filter>

          Card-2: Qualcomm Atheros AR9485 Wireless Network Adapter driver: ath9k

          IF: wlp3s0 state: up mac: <filter>

Drives:    HDD Total Size: 1000.2GB (19.6% used)

          ID-1: /dev/sda model: ST1000LM024_HN size: 1000.2GB

Partition: ID-1: / size: 50G used: 39G (82%) fs: ext4 dev: /dev/dm-0

          ID-2: /boot size: 976M used: 159M (18%) fs: ext4 dev: /dev/sda2

          ID-3: /home size: 859G used: 138G (17%) fs: ext4 dev: /dev/dm-2

          ID-4: swap-1 size: 8.32GB used: 0.00GB (0%) fs: swap dev: /dev/dm-1

RAID:      No RAID devices: /proc/mdstat, md_mod kernel module present

Sensors:  System Temperatures: cpu: 47.0C mobo: N/A

          Fan Speeds (in rpm): cpu: N/A

Info:      Processes: 352 Uptime: 2 days Memory: 5437.9/7799.4MB Client: Shell (bash) inxi: 2.3.8

Thanks for pointing me to yet another interesting piece of the Linux jigsaw.

Cheers,
Doug.