mongodb hot backup and cold backup

Does mongodb hot backup refer to operations implemented using mongodump, etc.? What about cold backup?

曾经蜡笔没有小新 2017-05-17 10:02:47 0  1  799

Create backups of MySQL databases and servers

I understand MySQL database backup, but how to backup the entire MySql configuration and database? I'm building a few sets of services/tools and I need to provide instructions so that less technical people can restore them in my absence. One of the things I need to back up is self-hosted MySql. Can ...

P粉506963842 2024-03-20 11:11:09 0  1  382

How to backup phpstuy.

How to backup phpstuy

phpcn_u103305 2018-01-29 06:32:01 0  2  1619

Make a backup of mysql for online projects

For a project running online, how to back up the database without stopping the database?

简单点 2018-07-30 14:57:05 0  2  1193

Backup of PostgreSQL database design - no data

I'm trying to find a way to backup my database design without including the data stored in the database. Actually, one might say I want a file containing all "CREATEScripts" in the database. Ideally, this file can be used to recreate the database (without the data of course). How to avoid ...

P粉098417223 2023-08-24 14:29:36 0  1  629

php - Wordpress mysql data recovery problem, novice please help!

1. My WordPress website could not be opened. At that time, I could not use the WordPress plug-in to back up the data into sql format, so I had to back up all the mysql folder and theme plug-ins. 2. After reinstalling WordPress, I created a database with the same name as before, table prefix, account...

阿神 2017-07-07 10:35:20 0  3  1265

Recovering MySql tables from .ibd files: an ongoing challenge

The MySQL server suddenly stopped working, the service would be intermittent and I couldn't make a backup because the service wasn't running, so the best I could do was copy the entire DATA folder. Also, I had an older backup so using that along with the ibd file restored all the tables except the l...

P粉848442185 2023-12-30 12:03:47 0  1  604

Who can play Empire Backup?

ot FoundThe requested URL /upload was not found on this server. What should I do if I open the directory? Urgent, please help.

㍿︻☯▅▆▇◤☠ 2017-12-20 02:12:29 0  1  965

Rewritten title: "How to subtract bigint value as year in MySQL"

I have a MySQL database that contains a bigint column called years_valid_for and a datetime(6) column called completion_date. I need to subtract the year from a bigint column. For example, years_valid_for is 4 and completion_date is 2023-06-07. I need to subtract 4 years from 2023-06-07 to get 2019-...

P粉561438407 2023-09-13 13:15:06 0  2  557

MYSQL query to copy all data in a column from one database to another

I accidentally used the "Generate Description" feature on the Opencart SEO tool and it overwrote all of my product descriptions with the product title. I have over 600 products and it would be a pain to remake them all. I have a MYSQL backup from 2 months ago that contains most of the prod...

P粉005417748 2024-04-01 00:00:37 0  1  523

Initializing a container to run on MySQL using Kubernetes

I'm running mysql as an init container of a kubernetes deployment. For various reasons I need to start mysql in the init container/restore a backup of mysql -> save it into a pvc and then the main pod will be a mysqlpod with the data attached to it. This is because I need to take a snapshot of th...

P粉315680565 2024-03-26 19:48:31 0  1  403

How to undo an executed mysql UPDATE command

I was trying to make an update to my MySQL server and accidentally forgot to add an extra WHERE clause that was supposed to edit a row. Over 3500 lines have now been edited due to my mistake. I may have a backup, but I've done a lot of work since the last backup and I don't want to waste all that wo...

P粉464113078 2023-08-22 17:36:22 0  2  573

mysql - How to restore tables from .idb files backed up by Alibaba Cloud

How to restore tables from Alibaba Cloud's .idb file.

typecho 2017-06-12 09:22:27 0  1  948

How to implement decreasing balance using MySQL

How to create a declining balance query using mysql to calculate depreciation in accounting. For example, equipment costs $16,000, has an estimated useful life of 5 years, and has a depreciation rate of 40%. Depreciation year starting book value depreciation rate ending depreciation amount book valu...

P粉473363527 2023-09-01 21:11:53 0  1  676

phpsstudy upgrade procedure is not done well. Upgrade fails every time

Every upgrade is unsuccessful. It takes a lot of time to deal with upgrade issues. For example, there is no backup when upgrading the database and there is no backup when upgrading the site configuration. The upgrade procedure was not done properly. It’s really a trap. It's better not to upgrade. I ...

2 2018-11-22 10:06:17 0  1  982

Deprecated: The file wp-db.php is deprecated as of version 6.1.0! Use wp-includes/class-wpdb.php instead. exist

After updating wordpres, this error appears at the top of the page. I also cannot log into wordpres as administrator and restore the backup. I don't know what to do Deprecated: The file wp-db.php is deprecated as of version 6.1.0! Use wp-includes/class-wpdb.php instead. Warning: Cannot modify header...

P粉346326040 2023-12-18 19:53:32 0  1  658

Find year range for Mysql REGEXP

I want to separate the content in a table on my movie website based on year intervals, but no matter how hard I try, I can't succeed. Actually what I want is to list movie files before 1950. I don't know if I made a syntax error because I'm a beginnerAMovie1910BMovie1920CMovie1930DMovie1940EMovie195...

P粉545910687 2024-04-01 14:26:29 0  1  513