Ygthkb

It took me a lot of time to make this, pls like. (YouTube Comments #1)

Closed form for these polynomials?

Program that converts a number to a letter of the alphabet

What to do when being responsible for data protection in your lab, yet advice is ignored?

How can I improve my fireworks photography?

Why did Bush enact a completely different foreign policy to that which he espoused during the 2000 Presidential election campaign?

Dilemma of explaining to interviewer that he is the reason for declining second interview

Everyone is beautiful

Eww, those bytes are gross

What's the most convenient time of year in the USA to end the world?

What formula could mimic the following curve?

I am on the US no-fly list. What can I do in order to be allowed on flights which go through US airspace?

What's a good word to describe a public place that looks like it wouldn't be rough?

Knowing when to use pictures over words

Can a hotel cancel a confirmed reservation?

Can I become debt free or should I file for bankruptcy? How do I manage my debt and finances?

Could flying insects re-enter the Earth's atmosphere from space without burning up?

Why is button three on trumpet almost never used alone?

How can animals be objects of ethics without being subjects as well?

Why are the books in the Game of Thrones citadel library shelved spine inwards?

How is the Incom shipyard still in business?

What is the etymology of the kanji 食?

Why zero tolerance on nudity in space?

Approaches to criticizing short fiction

Batch query a lot of MySQLdump files

How to change data structure in mysql using mysqldump without deleting filesmysqldump dump file sizemysqldump confusionMysqldump without slow queryHowto restore Trigger filesystem copy (*.TRG and *.TRN files) in addition to mysqldump?MYSQLDUMP --skip-lock-tablesmysqldump errorMysqldump, exclude data from tables by queryMariaDB Query slower after mysqldumpMysql: set variable in mysqldump

0

I have a website for an event. I set up a cron job to back up the database every hour. The backup command is

mysqldump -u"$DB_USER" -p"$DB_PASS" --database "$DB_NAME" >"${OUTPUT_DIR}/${DB_NAME}.$(date +%Y%m%d-%H%M%S).sql"



# crontab: 30 * * * * /path/to/backup_db.sh

I have 200+ of files like this in the backup directory (pulled from server):

$ ls -1 "$OUTPUT_DIR"

ibug.20190301-133002.sql

ibug.20190301-143001.sql

ibug.20190301-153001.sql

ibug.20190301-163001.sql

ibug.20190301-173001.sql

...

The files aren't very big by themselves, averaging less than 2 MB each but summing up to more than 400 MB.

The top few lines of a dump is

-- MySQL dump 10.14  Distrib 5.5.60-MariaDB, for Linux (x86_64)

--

-- Host: localhost    Database: ibug

-- ------------------------------------------------------

-- Server version   5.5.60-MariaDB

I want to perform a series of SELECT queries on each dump (data analysis). The queries range from simple SELECT COUNT(*) ones to complex ones with multiple JOINs and multiple subqueries (all are SELECT).

While it's possible, I don't want to write a script to import them one by one and run the queries. I wonder if there is another better approach.

---

My local machine is running on 10.1.38-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04 (not exactly MySQL, it's Maria).

I have (I believe) enough skills and knowledge in Python and Bash (and regular expressions) for a moderately complex script to batch or automate the job, not sure if this is relevant, though.

mysql mariadb mysqldump query

share

edited 2 mins ago

SELECT iBug FROM users

asked 8 mins ago

SELECT iBug FROM usersSELECT iBug FROM users

1013

New contributor

SELECT iBug FROM users 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 have a website for an event. I set up a cron job to back up the database every hour. The backup command is

mysqldump -u"$DB_USER" -p"$DB_PASS" --database "$DB_NAME" >"${OUTPUT_DIR}/${DB_NAME}.$(date +%Y%m%d-%H%M%S).sql"



# crontab: 30 * * * * /path/to/backup_db.sh

I have 200+ of files like this in the backup directory (pulled from server):

$ ls -1 "$OUTPUT_DIR"

ibug.20190301-133002.sql

ibug.20190301-143001.sql

ibug.20190301-153001.sql

ibug.20190301-163001.sql

ibug.20190301-173001.sql

...

The files aren't very big by themselves, averaging less than 2 MB each but summing up to more than 400 MB.

The top few lines of a dump is

-- MySQL dump 10.14  Distrib 5.5.60-MariaDB, for Linux (x86_64)

--

-- Host: localhost    Database: ibug

-- ------------------------------------------------------

-- Server version   5.5.60-MariaDB

I want to perform a series of SELECT queries on each dump (data analysis). The queries range from simple SELECT COUNT(*) ones to complex ones with multiple JOINs and multiple subqueries (all are SELECT).

While it's possible, I don't want to write a script to import them one by one and run the queries. I wonder if there is another better approach.

---

My local machine is running on 10.1.38-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04 (not exactly MySQL, it's Maria).

I have (I believe) enough skills and knowledge in Python and Bash (and regular expressions) for a moderately complex script to batch or automate the job, not sure if this is relevant, though.

mysql mariadb mysqldump query

share

edited 2 mins ago

SELECT iBug FROM users

asked 8 mins ago

SELECT iBug FROM usersSELECT iBug FROM users

1013

New contributor

SELECT iBug FROM users 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 have a website for an event. I set up a cron job to back up the database every hour. The backup command is

mysqldump -u"$DB_USER" -p"$DB_PASS" --database "$DB_NAME" >"${OUTPUT_DIR}/${DB_NAME}.$(date +%Y%m%d-%H%M%S).sql"



# crontab: 30 * * * * /path/to/backup_db.sh

I have 200+ of files like this in the backup directory (pulled from server):

$ ls -1 "$OUTPUT_DIR"

ibug.20190301-133002.sql

ibug.20190301-143001.sql

ibug.20190301-153001.sql

ibug.20190301-163001.sql

ibug.20190301-173001.sql

...

The files aren't very big by themselves, averaging less than 2 MB each but summing up to more than 400 MB.

The top few lines of a dump is

-- MySQL dump 10.14  Distrib 5.5.60-MariaDB, for Linux (x86_64)

--

-- Host: localhost    Database: ibug

-- ------------------------------------------------------

-- Server version   5.5.60-MariaDB

I want to perform a series of SELECT queries on each dump (data analysis). The queries range from simple SELECT COUNT(*) ones to complex ones with multiple JOINs and multiple subqueries (all are SELECT).

While it's possible, I don't want to write a script to import them one by one and run the queries. I wonder if there is another better approach.

---

My local machine is running on 10.1.38-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04 (not exactly MySQL, it's Maria).

I have (I believe) enough skills and knowledge in Python and Bash (and regular expressions) for a moderately complex script to batch or automate the job, not sure if this is relevant, though.

mysql mariadb mysqldump query

share

edited 2 mins ago

SELECT iBug FROM users

asked 8 mins ago

SELECT iBug FROM usersSELECT iBug FROM users

1013

New contributor

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

mysqldump -u"$DB_USER" -p"$DB_PASS" --database "$DB_NAME" >"${OUTPUT_DIR}/${DB_NAME}.$(date +%Y%m%d-%H%M%S).sql"



# crontab: 30 * * * * /path/to/backup_db.sh

$ ls -1 "$OUTPUT_DIR"

ibug.20190301-133002.sql

ibug.20190301-143001.sql

ibug.20190301-153001.sql

ibug.20190301-163001.sql

ibug.20190301-173001.sql

...

-- MySQL dump 10.14  Distrib 5.5.60-MariaDB, for Linux (x86_64)

--

-- Host: localhost    Database: ibug

-- ------------------------------------------------------

-- Server version   5.5.60-MariaDB

share

edited 2 mins ago

SELECT iBug FROM users

asked 8 mins ago

SELECT iBug FROM usersSELECT iBug FROM users

1013

New contributor

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

share

edited 2 mins ago

SELECT iBug FROM users

asked 8 mins ago

SELECT iBug FROM usersSELECT iBug FROM users

1013

New contributor

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

asked 8 mins ago

SELECT iBug FROM usersSELECT iBug FROM users

1013

New contributor

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

asked 8 mins ago

SELECT iBug FROM usersSELECT iBug FROM users

1013