'ilike' or 'not ilike'
return $query->where('api_call', 'not ilike', '%TEST%');
'ilike' or 'not ilike'
return $query->where('api_call', 'not ilike', '%TEST%');
Fastest way to import data over time found to be csv format data
mysql> load data local infile 'Desktop/data.csv'
-> INTO TABLE cars
-> FIELDS TERMINATED BY ','
-> ENCLOSED BY '"'
-> LINES TERMINATED BY '\n'
-> IGNORE 1 ROWS;
Query OK, 232880 rows affected, 65535 warnings (27.87 sec)
Records: 232880 Deleted: 0 Skipped: 0 Warnings: 232880
mysql -h xxxxxxxxxta.us-east-1.rds.amazonaws.com -u admin -p
SELECT User,Host FROM mysql.user;
SHOW GRANTS FOR 'drupal'@'%';
TablePlus(Mac)
DBeaver
Mysql Workbench
SequelPro
#1 mysql h xxxxx.com -u username -p dbname < dbexport.sql
OR
#1 mysql h xxxxx.com -u username -p
#2 use database-name;
#3 source file.sql
sudo mysqldump --all-databases -udxxxx -p > oct-16-2019-database.sql
mysqldump --databases xxxxxx-name -udxxxx -p > oct-16-2019-database-david-raleche.sql
NOT A ROOT USER
mysqldump –all-databases> database.sql
mysqldump -all-databases -uuser -ppassword> database.sql
mysqldump –all-databases –skip-lock-tables -u user-ppassword > Sept2018database.sql
Explain
select table_schema, sum((data_length+index_length)/1024/1024) AS MB from information_schema.tables group by 1;
mysqldump -uroot -p MyDatabase >/home/users/backup_MyDB/$(date +%F)_full_myDB.sql
Create new User
– Full privileges