Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

All Questions

Tagged with
Filter by
Sorted by
Tagged with
2
votes
2answers
17 views

Restore mysql database with some columns content enclosed by " and another not

We have to restore a database in MySQL but some columns have content enclosed by " and another not like in this sample: 00.168.93.70,null,ES,0,htc,33a48a1515b20691,"htc;HTC One (REL4.4.2)",m7,...
0
votes
1answer
42 views

How do I skip an offline database over the network in MySQL import?

I am doing a MySQL import from an *.sql file to multiple database location over the network. I'm using cmd batch file to run the command and it's working as I expect it to be. However I notice that ...
0
votes
1answer
21 views

Restoring MySQL 8.0 server from cold backup files

Recently, my database server running MySQL 8.0 crashed due to power outage. I have access to a cold backup (i.e., all physical files) of the server before the crash occurred. I do not have any other ...
0
votes
0answers
16 views

mysql db data folder restore in 5 days old backup [duplicate]

recently I had the need to install a driver on a server and because of the destination I finished uninstalling XAMPP in which I had a database that I need to recover. The fact is that after ...
0
votes
1answer
111 views

Error Unknown command '\U' when restoring MySQL dump on Windows

I am updating software that used MySQL 5.4.3 in its old version, and now uses MariaDB 10.2.11. So, I dumped the old data with that command: mysqldump -uroot -p --no-create-info --skip-triggers --...
0
votes
1answer
52 views

Can you restore purged MySQL binary logs?

I have two situations I need some clarification. 1) Let's say I made a backup of all the MySQL binary logs before I purged a single binary log file (the oldest one, possibly the very first one). ...
0
votes
0answers
40 views

error while restoring database from mysql: ERROR 1006 (HY000)

I made a mysqldump from all my databases prior to fully deinstall and reinstall MariaDB. while restoring the databases with the following command, logged in as root: MySQL -u root -p < /mnt/...
0
votes
0answers
65 views

Restore a 140GB - 292 Million entrie MySQL-Database faster?

i need help. I have an old innodb Server and my storage limit reached. I dont use files per table entries because in old times there were no ability at this time. My ibdata grown up fast and there is ...
0
votes
0answers
343 views

how to dump mysql schema without keys and without constraint ? and keep all of them to alter afterwards

i am using ubuntu 16.04 and want to dump large schema with hounded of tables from AWS rds, remove all keys and foreign key , load data and then add back the keys , is there any automatic tool that ...
0
votes
1answer
140 views

How to restore mysqldump of one database in different databaseName with content of data in the same host machine

Let's start from the beginning there is a MySQL database with name DB1. As I want to restore the mysqldump backup of DB1 database in DB2. The DB2 database is another database in same Host Server ...
0
votes
0answers
69 views

How to speed up MySQLl loading from dump file?

I'm using mysqld Ver 5.7.25-0 in Ubuntu 16.04. I dumped from AWS Relational Database Service (RDS) with mysqldump --single-transaction --quick --max_allowed_packet 1G ... and now when I tried to load ...
0
votes
0answers
27 views

Proper way to fully backup and restore a database including indexes in a low-resource shared web host with ssh access?

I'm rather new to database management and I would like some advice on better practices by using the following experience as an example. Every time I update php software I do a quick export from ...
0
votes
0answers
172 views

MariaDB 10.2 crash on innodb table corruption - trying to restore the database

I'm running MariaDB 10.2 on Windows and had some hard drive corruption on my server that messed up some innodb tables. Unfortunately this also affected backups, so I'm trying to dump the tables and ...
0
votes
0answers
261 views

What steps can I take to recover MySQL InnoDB databases when forced recovery fails?

Coming here from StackOverflow because I saw a similar question being closed as off-topic on there. I have corrupted my local MySQL instance in my development environment. I was running a set of ...
0
votes
0answers
45 views

point in time recovery not working with blackhole engine tables involved

The basic problem summary: I am trying to do a point in time recovery on a specific table. To speed things up I made every other table use the blackhole engine. Unfortunately this runs into errors ...
0
votes
2answers
52 views

What are the different ways to restore a database?

From the most inoffensive of the cases, to the worst of the scenarios they know. What are the different ways to restore or recover a MySQL database? I refer to the use of full backups and incremental ...
2
votes
1answer
35 views

Recover a broken or damaged database from the transaction file or “journal”

A greeting fellow, I would like to know if in MySQL (I understand that all engines must have), you can recover from damage to the database using some kind of file "journal" transactions, if so, what ...
0
votes
2answers
130 views

Replace some rows in one table with rows of another table

I have two tables and a set of primary key values. I want to replace all rows of the first table whose primary keys are in this set with the corresponding (having the same primary key) rows of the ...
1
vote
0answers
253 views

Restoring table structure with mysqlfrm

I'm trying to restore an old MySQL database and its tables by using the .frm and .ibd files. First I tried restoring the structure by using the following command I found in another post: mysqlfrm....
0
votes
1answer
1k views

Recovering MySQL 5.7 tables in MariaDB 10

I did a very foolish thing... I did not realize installing mariaDB would uninstall MYSQL 5.7 using apt-get. (Using Ubuntu 16.04). So now I am trying to recover my data. So far, I have read many ...
1
vote
2answers
697 views

Repair/Recover data from MySQL database

I have a big problem with a MySQL database stored on my raspberry (InnoDB engine). I'm not very expert in this field but I'll try to explain to you the problem. MySQL crash everytime that I try to ...
0
votes
1answer
1k views

Mysql Restore - ERROR 1227 (42000) at line 30908: Access denied DEFINER issue

Im trying to restore the database dump which has the DEFINER=test@%. Backup file is 50GB. OS - CentOS 7.5 While restoring this, I got the below error. ERROR 1227 (42000) at line 30908: ...
0
votes
0answers
133 views

MySQL8 Restore from Physical Files - Innodb

I recently had one of my VM's go down (MS Server 2016) and the only version I am able to get up and running is two weeks old. However, I do have a backup of my C:/ drive from last night that has my C:/...
0
votes
1answer
1k views

MariaDB: point in time backup recovery with binary log using position

Following the below sequence of commands i expected the recovery of backup and subsequent point in time recovery using binary log. However, the database was restored to backup only: 1) CREATE TABLE ...
0
votes
1answer
928 views

delete tables on import of dump created by mysqldump

There are 2 copies of the same database on 2 different storages which need to be in sync. For example, database named test_db contains tables T1,T2,T3 tables. T2,T3 are deleted. Dump of the 1st copy ...
1
vote
0answers
135 views

MySql could not restore whole dump file

MySql cluster is unable to restore whole dump file. Error: MaxNoOfConcurrentOperations and increase MaxNoOfAttributes This is the command I tried: mysql -u username -p create database ...
0
votes
1answer
409 views

Cannot recover Database from ibdata file

My Server recently had a Kernel-Panic and I downloaded all the mysql data using the rescue mode. Now when I upload the ibdata1 file and table folders to a local XAMPP Server and click on a table to ...
1
vote
1answer
54 views

MySQL - Order of Table Load From Backup

I need to load a database backup from some months ago.There are 29 tables backed up as individual.sql files. Is the order I load them important? For instance the ClientSupplementary table has a FK ...
0
votes
1answer
71 views

Unistalled MySQL 5.6 and installed MySQL 5.7 - Restore Database and Tables

All of the data resides in "C:\ProgramData\MySQL\MySQL Server 5.6\data". There are 46 folders inside of this folder. There is one folder for every old database I had. For example the first three ...
0
votes
1answer
49 views

Can I restore a MySQL table from a file (non-sql) backup?

I am using XAMPP 5.6.23-0 on a Mac. I have experienced many problems with MySQL, where the server simply refuses to restart after something has happened (not sure which events make it crash). In the ...
0
votes
1answer
471 views

MySQL - Restore 1TB database using myloader

Im trying to restore a database which is 1.3TB and its in AWS Aurora. I want to restore a copy of this database to an EC2 instance(32 vCPU, 244GB MEMORY). I used mydumper to take backup from AWS RDS ...
2
votes
1answer
780 views

MySQL - Fastest restore of 1TB database

I have MySQL Database and its 1.5TB. I need to setup replication for this. I have 32core CPU and 250GB Memory. The problem restore is taking more time even I used mydumper/myloader to backup and ...
0
votes
1answer
2k views

When to use mysqldump with '--no-autocommit'? My benchmark shows slower restore

I tested quick and dirty --no-autocommit vs. without this option on MacBook (installed with Homebrew latest MariaDB). I restored to an empty MariaDB a 4.6 GB *.sql file. The dump made without --no-...
4
votes
3answers
2k views

Migrating 300 GB mysql database from one server to another cleanly with minimum downtime

I have a 300 GB mysql database which i want to migrate to another server in order to setup Master-Master replication between the two and my main aim is to achieve this with least possible downtime. ...
0
votes
2answers
44 views

mysqldump file restore while sql is still being dumped

Im using MaridaDB 10, but my question applies to all mysql variants. I have large dataset (70GB uncomressed when dumped to file). The mysqldump process takes 2-3hours. The restore process takes even ...
1
vote
1answer
2k views

MySQLfrm - Using multiple frm files

I am busy rebuilding an entire MySQL DB. There are multiple schemas and multiple tables in each schema. I am restoring them using *.frm files as all other methods used have either failed or corrupted ...
1
vote
0answers
397 views

Missing tables from MySQL restore

I'm not a DBA but a JIRA admin. I run a cron backup of my mysql InnoDB JIRA database which runs a script that executes the command below: mysqldump -v --single-transaction --user=DATABASEUSER --...
1
vote
0answers
100 views

Other databases deleted after restoring incremental MySQL Enterprise Backup

I am trying to restore some databases, which were backed up with MySQL Enterprise Backup (MEB). The backup uses both full compressed backups and incremental backups. There is no problem if I restore ...
1
vote
0answers
648 views

MySQL MyISAM corrupted table repair failure

My MyISAM tables got corrupted(I guess due to fs corruption) filesystem_cstor.MDS_DATA warning : Table is marked as crashed warning : Table is marked as crashed error : Key in wrong position at ...
1
vote
2answers
82 views

Is there a way to speed up restoring data from MySQL to PostgreSQL?

OS: Windows10 x64 HDD: 1TB RAM: 8GB CPU: Intel Core i5-4460 PostgreSQL: 9.6 I want to import almost 37GB data from MySQL into PostgreSQL, and the data is sql file, which full of INSERT INTO tbl_1 ...
0
votes
1answer
224 views

Restore database in workbench from a Linux file

We have a database on a Linux server. Instead of restoring using command line, can I restore it from Workbench? My backup file is in a Linux data directory.
3
votes
2answers
1k views

Fast backup & restore of MySQL database to revert recent changes

I have a decently big MySQL DB (InnoDB) with size about 400 MB. Thus dumping the whole DB with mysqldump and restoring it back takes forever (more than 15 minutes, which is unacceptable). For ...
0
votes
1answer
147 views

recovery with binlogs?

I would like to know if there is a way that I can restore my databases, I don't have a replication and I would like to migrate my databases without downtime or losing data. So with binlogs could I do ...
1
vote
0answers
137 views

Cannot read sql statement into mysqlbinlog

Mysql 5.7 on Windows: show global variables like 'binlog_format'; using me the STATEMENT show master status; gives me log-bin.000053 Now I execute this: DELETE FROM test.emp WHERE EMPNO=109; ...
2
votes
1answer
306 views

Restoring MySQL database from small ibdata1

I've got a database from a dead Rasperry Pi, which I want to restore. As it doesn't boot anymore because of a damaged SD card, I only could recover the data files, but not do a normal dump. The server ...
0
votes
3answers
1k views

Huge mysqldump import

I have a 200+GB mysql dump file that I need to import into the local sql server running on my development machine. I attempted a naive dump restore using the mysql < db_backup.sql approach and ...
2
votes
1answer
69 views

MySQL Restore from a Year Old Backup

I have two backups created via mysqlhotcopy: backup-before-deletion from August 7, 2014 and backup-after-deletion from February 3, 2016 A deletion event occurred on July 17, 2015 which resulted in ...
1
vote
1answer
2k views

Fastest way to do a mysqldump restore on Amazon RDS?

We need to restore a database from a 7-Gb mysqldump file to a RDS Amazon instance. The full restore takes between 3 and 4 hours (probably because of network latency since the dump has to reside on a ...
1
vote
1answer
109 views

Duplicate table names after restoring a backup

I got this weird issue today when I restored a full .sql backup from one server to another server using dbForge Studio for MySQL (third party software). Both are having same properties like table ...
-1
votes
1answer
301 views

Accidentally dropped the 'mysql db' in my database, how can i restore it to back?

Accidentally dropped the 'mysql database' in my database, how can I restore it? I am using cpanel server.