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  638

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  387

Restore data - only the mysql data directory remains How to restore innodb data

I have newly installed mysql and used the previous directory. After opening it, I only see the table but no data. How can I restore it?

天蓬老师 2017-05-18 10:49:53 0  1  632

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  1274

How to resume database migration

I have a mysql database but I can't delete it. I'm missing my migration files in an asp.net project and I made some changes in the dbcontext file. When I try to create a new migration and update the database, it shows that table 'aspnetroles' already exists. what do I do? How to revert migration or ...

P粉418214279 2023-09-09 00:36:28 0  1  588

concurrency - Java concurrently processes a large amount of data in a table, how to set checkpoints so that they can be used for failure recovery instead of repeatedly processing the processed data?

Java concurrently processes a large amount of data in a table. How to set checkpoints for failure recovery instead of repeatedly processing the processed data? For example, if the system crashes during processing, and before kill -9 is used to force the kill, set a checkpoint and resume processing f...

滿天的星座 2017-05-17 10:08:26 0  1  707

Restore table structure from frm and ibd files

I'm trying to restore the database in the PMA but can only access the frm and ibd files - not the ib_log file which I understand you need. I know that I may not be able to recover the database data, but is it possible to recover the structure of the table from the frm file?

P粉637866931 2023-10-19 10:01:37 0  2  748

In MySQL database, how to copy one database to another database

A test environment database and a development environment database; the test environment database has been modified, but now the modified data needs to be restored to the original data, so how to copy the development environment database to the test environment database

P粉582593074 2023-08-10 10:34:20 0  0  503

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  1199

Engage in PHP-based word processing

I have retrieved data from MSSQL server table. Thanks to the query I am able to display them. I want to be able to modify this data without touching the table. For example, a value of 1 for enc_paye will show ("Order in preparation") and enc_prepared (Order ready). I would also like to kno...

P粉590929392 2023-09-02 22:45:43 0  2  512

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  547

javascript - axios upload data to php returns empty

1.vue 2.0 uses axios to upload data and returns empty, and the background is php 2.vue code {code...} 3.php code {code...} 4.console returns data {code...} 5. Remarks get Obtaining data is valid. For some reason, post submission data cannot be obtained on the php page, and the return is empty, htm.....

过去多啦不再A梦 2017-06-20 10:05:38 0  2  1003

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  423

I can't insert data. I don't know what went wrong.

<?php// Determine repeated passwords if(trim($_POST['pwd']) != trim($_POST['rpwd'])){ exit('The two passwords are inconsistent, please return to the previous page'); } // Ready to write data $username = trim($_POST['username']); // Visible

Ftd2014 2017-07-08 17:50:48 0  2  1825

php - mysql encoding format modification?

The problem is this: the encoding of an online table is utf8; but now it needs to be changed to utf8mb4. If the table data is not backed up and the encoding of the table and the corresponding field encoding are directly modified to utf8mb4, will it affect the data?

为情所困 2017-07-01 09:12:00 0  4  958

Help from a newbie: About the loop that generates static lists in PHP

Let me ask you guys, PHP generates a static list. After the loop, the database value is normal, but the generated html data keeps repeating the data of the first loop. for ($i=0; $i < $allpages; $i++){ if ($i==0) { $indexpath = "index_0.html";&nbsp

°无恙。 2019-05-22 18:00:06 0  1  1038

Why do replica sets on the same server and shards on different servers?

Why do replication sets on the same server and sharding on different servers? In this way, one server does not only have several copies of the same part of the data. If one of the servers hangs up, the other server will only have one piece of data.

Yan**** 2018-08-12 09:59:22 0  0  1304

After copying website to local, WordPress homepage redirects to duplicate copy

Background: I have multiple websites running on rpi4 using nginx and wordpress. I want to copy one of the sites to my local network for development and testing. I copied the database and WordPress files and set up a config file to listen on port 8082 and backup the database. The original website is ...

P粉459440991 2024-03-31 15:26:18 0  2  443

What is the default database name prefix in the php toolbox?

What is the default database name prefix in the php toolbox or where to view it. The following is the copied content information database name: root Which database should WordPress be installed to? Username: root Your MySQL username Password root...and its password Database host: 127.0.0.1 If localh...

彭离元 2019-07-08 02:23:41 0  1  1197

How to synchronize development and production databases

Do you know of any application that synchronizes two databases - during development sometimes you need to add a table row or two or a new table or column. Normally I write each sql statement to some file and execute the lines on my production database during the upload path (backing it up before). I...

P粉520204081 2023-10-22 23:37:30 0  1  747