MySQL Forums
Forum List  »  Newbie

Have a Database I Can't Backup: need to Do that because Need the Data
Posted by: Brian Baker
Date: October 25, 2021 05:04PM

Good Evening:

I am working on my server and I have a database I need to backup: I backed up ALL of the databases EXCEPT the one that I thought I had done in the last backup. I have the database in the /var/lib/mysql/<DATABASE NAME> like THIS:
================================================================================
drwx------ 2 mysql utempter 4096 Oct 25 01:07 auth2db
drwx------ 2 mysql mysql 4096 Oct 25 17:02 BBDI
drwx------ 2 mysql mysql 12288 Oct 25 17:03 bbus_board_2017
drwx------ 2 mysql mysql 4096 Oct 25 17:05 blog_2016
-rw-r--r-- 1 root root 0 Oct 25 01:06 debian-5.5.flag
drwx------ 2 mysql mysql 4096 Oct 25 17:08 DOT@002dCOM@002dMAIN_2017
drwx------ 2 mysql mysql 4096 Oct 25 17:24 DOT@002dORG@002dMAIN@002d2017
-rw-rw---- 1 mysql utempter 44040192 Oct 25 18:48 ibdata1
-rw-rw---- 1 mysql utempter 5242880 Oct 25 18:48 ib_logfile0
-rw-rw---- 1 mysql utempter 5242880 Oct 25 17:24 ib_logfile1
drwx------ 2 mysql root 4096 Oct 25 01:06 mysql
-rw------- 1 root root 6 Oct 25 01:06 mysql_upgrade_info
-rw-r--r-- 1 root root 5207988 Oct 25 18:13 old.mysql.tar
drwx------ 2 mysql utempter 4096 Oct 25 01:06 performance_schema
drwx------ 2 mysql utempter 4096 Oct 25 01:14 phpmyadmin
drwx------ 2 mysql mysql 4096 Oct 25 17:14 tcts_2017 <<WANT THIS DATA>>
==============================================================================
Inside that, I have this data:

otal 224
-rw-rw---- 1 mysql mysql 65 Oct 25 17:00 db.opt
-rw-rw---- 1 mysql mysql 8688 Oct 25 17:14 wp_commentmeta.frm
-rw-rw---- 1 mysql mysql 13380 Oct 25 17:14 wp_comments.frm
-rw-rw---- 1 mysql mysql 8626 Oct 25 17:14 wp_gallery_bank.frm
-rw-rw---- 1 mysql mysql 8722 Oct 25 17:14 wp_gallery_bank_meta.frm
-rw-rw---- 1 mysql mysql 13176 Oct 25 17:14 wp_links.frm
-rw-rw---- 1 mysql mysql 8822 Oct 25 17:14 wp_ngg_album.frm
-rw-rw---- 1 mysql mysql 8876 Oct 25 17:14 wp_ngg_gallery.frm
-rw-rw---- 1 mysql mysql 9042 Oct 25 17:14 wp_ngg_pictures.frm
-rw-rw---- 1 mysql mysql 8698 Oct 25 17:14 wp_options.frm
-rw-rw---- 1 mysql mysql 8682 Oct 25 17:14 wp_postmeta.frm
-rw-rw---- 1 mysql mysql 13684 Oct 25 17:14 wp_posts.frm
-rw-rw---- 1 mysql mysql 8682 Oct 25 17:14 wp_termmeta.frm
-rw-rw---- 1 mysql mysql 8666 Oct 25 17:14 wp_term_relationships.frm
-rw-rw---- 1 mysql mysql 8668 Oct 25 17:14 wp_terms.frm
-rw-rw---- 1 mysql mysql 8768 Oct 25 17:14 wp_term_taxonomy.frm
-rw-rw---- 1 mysql mysql 8684 Oct 25 17:14 wp_usermeta.frm
-rw-rw---- 1 mysql mysql 13064 Oct 25 17:14 wp_users.frm
===============================================================
I tried to do this backup by following a tutorial about how to do this in the event that you DON'T have a backup of this data. If I try to follow any tutorial, I am messing with permissions, and ib_* and ibdata files.

Is there a way to backup the data as it is listed? I NEED this database, and all I get when I follow those directions is ERRORS, and then mysql doesn't start!

Is there anything I can do to get this backed up??

Brian

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.