LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   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/)

Doug Hutcheson 06-21-2017 09:20 PM

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-)

Doug Hutcheson 06-22-2017 04:07 AM

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

jareklakman 06-22-2017 04:42 AM

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.

Habitual 06-22-2017 06:54 AM

Glad it worked out.

Doug Hutcheson 06-22-2017 07:11 PM

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

Doug Hutcheson 06-22-2017 07:21 PM

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.

Habitual 06-23-2017 04:42 AM

Quote:

Originally Posted by Doug Hutcheson (Post 5725885)
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.

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.

Doug Hutcheson 06-23-2017 10:35 PM

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.


All times are GMT -5. The time now is 03:44 AM.