Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with mysql
Search options not deleted
user 88204
All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.
-1
votes
1
answer
106
views
Get rows from child and from its child table
I want to get rows from child and from it's child table in MySQL. …
- 64
0
votes
MySQL: grant SELECT to all databases except system
below
create user reader@whatEverIPAddressOfUser identified by 'password';
grant select on . to reader@whatEverIPAddressOfUser;
flush privileges;
then issue your revoke statement
revoke SELECT ON mysql …
- 64
1
vote
Create a copy of the database in same server
do dump of your current database
mysqldump -p yourDatabase > file.sql
then create new database and restore file.sql
mysql -p -e "create database new_DB"
mysql -p new_DB < file.sql …
- 64
0
votes
The table 'table_name' is full in MySQL
I suggest you setup a script to run daily that archive older records (this will also reduce the load on that table since you mentioned it has over 300 million rows)
check percona pt-archiver
- 64
1
vote
MySQL server with root user that can be accessed remotely with just a password. How hard is ...
create a user with certain privileges (depends on what queries you run). I also advice to disallow root remotely login.
- 64
0
votes
dummyuser creating users
create a user with grant option privilege.
GRANT [whatever privilege to that normal user] TO 'normal_user'@'ipaddress' WITH GRANT OPTION IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
- 64
0
votes
Mysql - How can I replication structure, not data
to dump structure only
mysqldump --no-data -h localhost -u root -p mydatabase > mydatabase_backup.sql
for specific table/s
mysqldump --no-data -h localhost -u root -p mydatabase tablename > mydata …
- 64
0
votes
Reclaim disk space after drop table from database in mysql
mysql> OPTIMIZE table table_name;
for InnoDB tables, it run under ALTER operation.
reference: https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html …
- 64
0
votes
Slow MySQL sessions table
use explain on your query (it will provide output on your execution)
add index on your table
- 64
0
votes
MySQL replication still failing after new import
your_database_name > file.sql
--master-data=2 parameter will provide master's binary log position and file in file.sql
Restore the dump from master node in Slave node
login to slave and execute below
mysql … > STOP SLAVE; RESET SLAVE ALL;
mysql> CHANGE MASTER TO MASTER_HOST='Master Node IP',
MASTER_USER='replication_user',
MASTER_PASSWORD='replication_user_password',
MASTER_LOG_FILE=' …
- 64
1
vote
MYSQL database replication Error MY-002061
Example. in your Slave node do below,
mysql -h Master_Server_Ip -u replication_user -p
then monitor your slave node after doing above via SHOW SLAVE STATUS command …
- 64
1
vote
Accepted
MySQL Replication - 1 Master - 2 Slaves. Inserting works for One, not the other
Have you set your second slave to server_id = 3 (or depends on you, should be different from 1st slave)
and in mysql of second slave:
CHANGE MASTER TO MASTER_HOST='IP Address of Master Server',
MASTER_USER …
- 64