-
Re: Mysql with databases on HDD

Originally Posted by
sbb
All I want to do is backup (mysqldump) a couple of databases and move them over to a new host.
There are many ways of doing this:
a. The most obvious one is to copy the files from one server to the other
b. If you still want to do a mysqlump, there is a command line option to set the configuration file to use. In that configuratio file you can specify where the data files are
c. Make sure that the mysql.socket file is pointing to a rw location (that might have been your problem when it didn't start).
d. Start the MySQL server in 'console' mode.
Most of the time you should use a mysqld_safe script that does some housekeeping for you just in case. You can check all these options by using mysqld --help, the text will be version specific.
Check http://dev.mysql.com/doc/mysql/en/Up...g-to-arch.html for some information in how copy databases between servers.
Check http://dev.mysql.com/doc/mysql/en/Starting_server.html as a starting point to troubleshooting.
The mysql versions might be too different.
The datafiles are backward and forward compatible, check
--GN
Similar Threads
-
By kennmurrah in forum General Support
Replies: 0
Last Post: 02-28-2006, 07:45 PM
-
By mzee in forum Knoppix DVD
Replies: 17
Last Post: 10-12-2005, 08:48 AM
-
By tux_edo in forum Customising & Remastering
Replies: 1
Last Post: 01-22-2004, 12:53 PM
-
By Coume in forum General Support
Replies: 5
Last Post: 08-06-2003, 06:42 AM
-
By Terry@nz in forum General Support
Replies: 3
Last Post: 06-09-2003, 10:01 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules

AMD Ryzen 5 5500 Processor ( read Description)
$59.00

(LOT OF 20) Intel Core i5-8400 CPU 2.80GHz Desktop Processor (SR3QT)
$700.00

INTEL CORE I9-10940X X-SERIES PROCESSOR | 3.30GHZ | SRGSH
$179.99

Compo MSI B150I GAMING PRO AC LGA1151 16 Gb DDR4 + Cpu I7 6700+I/O Shields.
$159.00

Intel Core i7-9700 Octa-Core 3 GHz Desktop Processor LGA 1151
$79.99

Intel Core i5-12500T SRL5W 2GHz 18MB 6 Core Socket LGA1700 Desktop CPU Processor
$114.99

Intel Core i7-3770K 3.5 GHz Processor
$39.00

Intel Core i7-9700K Octa-Core 3.6 GHz Desktop CPU
$99.99

Intel Core i7-4770 3.40GHz Quad Core SR149 LGA 1150 CPU Processor tested
$35.00

INTEL CORE I9-10980XE PROCESSOR | 3.00GHZ | SRGSG
$299.99