Ygthkb

I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."

Find the smallest value of the function

Am I correct in stating that the study of topology is purely theoretical?

Count repetitions of an array

Taking headphones when quitting job

Does it take energy to move something in a circle?

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

How to not let the Identify spell spoil everything?

"Starve to death" Vs. "Starve to the point of death"

Boss asked me to sign a resignation paper without a date on it along with my new contract

Plausible reason for gold-digging ant

Is there a way to store 9th-level spells in a Glyph of Warding or similar method?

Why is it that Bernie Sanders is always called a "socialist"?

Does the US government have any planning in place to ensure there's no shortages of food, fuel, steel and other commodities?

Prevent Nautilus / Nemo from creating .Trash-1000 folder in mounted devices

Are the positive and negative planes inner or outer planes in the Great Wheel cosmology model?

What is the difference between "...", '...', $'...', and $"..." quotes?

Not a Long-Winded Riddle

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

A fantasy book with seven white haired women on the cover

Cat is tipping over bed-side lamps during the night

Broad Strokes - missing letter riddle

What species should be used for storage of human minds?

Eww, those bytes are gross

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

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 1 min ago

Simon MerrickSimon Merrick

101

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 1 min ago

Simon MerrickSimon Merrick

101

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 1 min ago

Simon MerrickSimon Merrick

101

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 1 min ago

Simon MerrickSimon Merrick

101

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 1 min ago

Simon MerrickSimon Merrick

101

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 1 min ago

Simon MerrickSimon Merrick

101

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 1 min ago

Simon MerrickSimon Merrick

101