LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 06-21-2017, 08:20 PM   #16
Doug Hutcheson
Member
 
Registered: Jun 2009
Location: Queensland
Distribution: Fedora 30; HP Pavilion 8Gb and Acer Aspire 16Gb; both Intel Core-i7
Posts: 285

Original Poster
Rep: Reputation: 22

Quote:
Originally Posted by Habitual View Post
I cannot tell, sorry.
Thanks anyway. I will keep bashing away until I beat it into submission. "8-)
 
Old 06-22-2017, 03:07 AM   #17
Doug Hutcheson
Member
 
Registered: Jun 2009
Location: Queensland
Distribution: Fedora 30; HP Pavilion 8Gb and Acer Aspire 16Gb; both Intel Core-i7
Posts: 285

Original Poster
Rep: Reputation: 22
Quote:
Originally Posted by Doug Hutcheson View Post
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
 
Old 06-22-2017, 03:42 AM   #18
jareklakman
LQ Newbie
 
Registered: Jun 2017
Posts: 14

Rep: Reputation: Disabled
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.
 
Old 06-22-2017, 05:54 AM   #19
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Abingdon, VA
Distribution: Catalina
Posts: 9,374
Blog Entries: 37

Rep: Reputation: Disabled
Glad it worked out.
 
Old 06-22-2017, 06:11 PM   #20
Doug Hutcheson
Member
 
Registered: Jun 2009
Location: Queensland
Distribution: Fedora 30; HP Pavilion 8Gb and Acer Aspire 16Gb; both Intel Core-i7
Posts: 285

Original Poster
Rep: Reputation: 22
Quote:
Originally Posted by jareklakman View Post
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
 
Old 06-22-2017, 06:21 PM   #21
Doug Hutcheson
Member
 
Registered: Jun 2009
Location: Queensland
Distribution: Fedora 30; HP Pavilion 8Gb and Acer Aspire 16Gb; both Intel Core-i7
Posts: 285

Original Poster
Rep: Reputation: 22
Quote:
Originally Posted by Habitual View Post
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.
 
Old 06-23-2017, 03:42 AM   #22
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Abingdon, VA
Distribution: Catalina
Posts: 9,374
Blog Entries: 37

Rep: Reputation: Disabled
Quote:
Originally Posted by Doug Hutcheson View Post
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.

Last edited by Habitual; 06-23-2017 at 05:04 AM.
 
Old 06-23-2017, 09:35 PM   #23
Doug Hutcheson
Member
 
Registered: Jun 2009
Location: Queensland
Distribution: Fedora 30; HP Pavilion 8Gb and Acer Aspire 16Gb; both Intel Core-i7
Posts: 285

Original Poster
Rep: Reputation: 22
Quote:
Originally Posted by Habitual View Post
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql import without overwriting existing data surferboy Linux - General 1 12-19-2012 08:51 AM
Import data from MySQL to MSSQL xeon123 Linux - General 2 05-06-2010 11:32 AM
import data back to mysql alaios Linux - General 2 02-27-2007 08:52 AM
import data to mysql server alaios Linux - Software 1 05-25-2005 12:37 AM
mysql data import bijuhpd Linux - Newbie 1 03-05-2005 08:01 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 05:59 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration