arrow_upward

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 5
  • 4
  • 3
  • 2
  • 1
How to backup server your files from rescue mode (with MySQL Backup)
#4
(05-22-2020, 08:32 PM)youssefbasha Wrote: Actually @"Hidden Refuge" you are right, seems that because my MySQL server didn't shut down well the files are unclean which caused me some errors in the database i moved like  #1033 - Incorrect information in file: './xx/xx.frm'
And i didn't figure out how can i fix this yet

I'm not sure if this is still relevant but, in any case here is the command for that (adjust it to your own case):
mysqldump -u root -p --host=localhost --port 3306 --default-character-set=utf8 --all-databases > /output_path/all_databases.sql

The above suppose that you remounted the filesystem and started mysqld.

Edit: To debug the #1033 error, you need to give us a lot more information than what's in the the quoted text.

Good luck!
VirMach's Buffalo_VPS-9 Holder (Dec. 20 - July 21)
microLXC's Container Holder (july 20 - ?)
VirMach's Phoenix_VPS-9 Holder (Apr. 20 - June 20)
NanoKVM's NAT-VPS Holder (jan. 20 - ?)


Messages In This Thread

Possibly Related Threads…
Thread
Author
Replies
Views
Last Post

person_pin_circle Users browsing this thread:
Sponsors: VirMach - Host4Fun - CubeData - Evolution-Host - HostDare - Hyper Expert - Shadow Hosting - Bladenode - Hostlease - RackNerd - ReadyDedis - Limitless Hosting