mySQL

12th October, 2022

Updated: 12th October, 2022

Create DB

CREATE USER ‘blah’@‘1.2.3.4' IDENTIFIED BY ‘password';
create database dynamo;
GRANT ALL PRIVILEGES ON dynamo.* TO ‘blah’@‘1.2.3.4';
FLUSH PRIVILEGES;

Conect to DB

mysql -u root -p stage

Backup existing stage DB:

mysqldump -u root –p stage > output.sql

export db as zip

mysqldump mps | gzip > mps.sql.gz

Log on to mysql:

mysql –u root –p stage

Drop existing database:

Drop database dbname;

Create new DB:

create database stage;

import SQL

mysql –u root –p dbname < import.sql

source /home/changes.sql

dump sql

-h = hostname

mysqldump -h *.eu-west-1.rds.amazonaws.com -u root -p dbname > dbname_yyyymmdd.sql

character lengths

-- Legnths of data

SELECT course_id, title, CHAR_LENGTH(aims) as 'lengthofaims', CHAR_LENGTH(objectives) as 'lengthofobjectives'
FROM offline_course
ORDER BY  `lengthofobjectives` DESC


-- legnth over x

SELECT course_id, title, CHAR_LENGTH(aims) as 'lengthofaims'
FROM offline_course
WHERE CHAR_LENGTH(aims) >= 750
ORDER BY `lengthofaims` DESC
```# Get users

```sql
select User,Host from mysql.user \g;

create user

faf75432-9d20-4161-9a7c-e4b4fbe53643

Created on: 12th October, 2022

Last updated: 12th October, 2022

Tagged With:

mysql