Sfrgttk

Translation needed for 130 years old church document

Non-Cancer terminal illness that can affect young (age 10-13) girls?

Converting very wide logos to square formats

Does the ditching switch allow an A320 to float indefinitely?

How to write cases in LaTeX?

Why did Luke use his left hand to shoot?

In harmony: key or the flow?

How much mayhem could I cause as a fish?

Why do all the books in Game of Thrones library have their covers facing the back of the shelf?

Why is 'diphthong' pronounced the way it is?

What makes papers publishable in top-tier journals?

Does an Eldritch Knight's Weapon Bond protect him from losing his weapon to a Telekinesis spell?

Count repetitions of an array

What's after EXPSPACE?

Broad Strokes - missing letter riddle

Should I cite R or RStudio?

What to do with threats of blacklisting?

Is there a verb that means to inject with poison?

How do I prevent a homebrew Grappling Hook feature from trivializing Tomb of Annihilation?

How big is a framed opening for a door relative to the finished door opening width?

Reading Mishnayos without understanding

Will rerolling initiative each round stop meta-gaming about initiative?

What can I do to encourage my players to use their consumables?

What is the wife of a henpecked husband called?

Tables missing from MySQL database after removing then restoring the mysql data direcory

How to change data location on UbuntuMySQL InnoDB logfiles resized - review mysql-err.log for potential problemsIssue after moving the ib_logfile1 and ib_logfile0 filesMoving mysql datadir cause info: checking for tables which need an upgradeMoving datadir OK start, but socket error for mysql clientMySQL does not start - Ubuntu 14.04 LTS after migration to new diskMySQL innodb_log_file_size change is not being recognizedMySQL explain results different after adding and then removing indexxtrabackup doesn't copy the binary log files (mysql-bin.xxxxx) shall i copy them manually? [solved]unable to communicate sql node with management-server

0

I Carried out the following operations.

make mysqldump of testdb

# Stop service

/etc/init.d/mysql stop

# Create copy of directory

cd /var/lib

cp -R mysql mysql.backup

# Delete datafile on disk

rm -rf mysql/testdb

# Start service

/etc/init.d/mysql start 

At this stage I was going to import testdb again from the mysqldump however we wanted to roll back for an unrelated reason so I restored the mysql file

/etc/init.d/mysql stop

rm -rf mysql/

cp -R mysql.backup mysql

# Restore ownership and permissions

chown -R mysql:mysql mysql

chmod -R 700 mysql

At this point testdb shows up if I run show databases; and it shows tables but doesn't appear to contain data any more.

Is this recoverable or am I wasting my time? I have the option of refreshing the db from prod

mysql linux mysql-5.7 recovery

share

asked 5 mins ago

Simon MerrickSimon Merrick

1011

New contributor

Simon Merrick is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I Carried out the following operations.

make mysqldump of testdb

# Stop service

/etc/init.d/mysql stop

# Create copy of directory

cd /var/lib

cp -R mysql mysql.backup

# Delete datafile on disk

rm -rf mysql/testdb

# Start service

/etc/init.d/mysql start 

At this stage I was going to import testdb again from the mysqldump however we wanted to roll back for an unrelated reason so I restored the mysql file

/etc/init.d/mysql stop

rm -rf mysql/

cp -R mysql.backup mysql

# Restore ownership and permissions

chown -R mysql:mysql mysql

chmod -R 700 mysql

At this point testdb shows up if I run show databases; and it shows tables but doesn't appear to contain data any more.

Is this recoverable or am I wasting my time? I have the option of refreshing the db from prod

mysql linux mysql-5.7 recovery

share

asked 5 mins ago

Simon MerrickSimon Merrick

1011

New contributor

Simon Merrick is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I Carried out the following operations.

make mysqldump of testdb

# Stop service

/etc/init.d/mysql stop

# Create copy of directory

cd /var/lib

cp -R mysql mysql.backup

# Delete datafile on disk

rm -rf mysql/testdb

# Start service

/etc/init.d/mysql start 

At this stage I was going to import testdb again from the mysqldump however we wanted to roll back for an unrelated reason so I restored the mysql file

/etc/init.d/mysql stop

rm -rf mysql/

cp -R mysql.backup mysql

# Restore ownership and permissions

chown -R mysql:mysql mysql

chmod -R 700 mysql

At this point testdb shows up if I run show databases; and it shows tables but doesn't appear to contain data any more.

Is this recoverable or am I wasting my time? I have the option of refreshing the db from prod

mysql linux mysql-5.7 recovery

share

asked 5 mins ago

Simon MerrickSimon Merrick

1011

New contributor

Simon Merrick is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

# Stop service

/etc/init.d/mysql stop

# Create copy of directory

cd /var/lib

cp -R mysql mysql.backup

# Delete datafile on disk

rm -rf mysql/testdb

# Start service

/etc/init.d/mysql start 

/etc/init.d/mysql stop

rm -rf mysql/

cp -R mysql.backup mysql

# Restore ownership and permissions

chown -R mysql:mysql mysql

chmod -R 700 mysql

share

asked 5 mins ago

Simon MerrickSimon Merrick

1011

New contributor

Simon Merrick is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 mins ago

Simon MerrickSimon Merrick

1011

New contributor

Simon Merrick is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

Simon MerrickSimon Merrick

1011

New contributor

Simon Merrick is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

Simon MerrickSimon Merrick

1011