mysqldump   349

« earlier    

Use mysqldump to Back Up MySQL or MariaDB
Use mysqldump to back up MySQL databases, tables, or entire database management systems.
mysql  mysqldump 
5 weeks ago by arobinski
MySQL Bugs: #19611: missleading error message while using defaults-extra-file parameter | https://bugs.mysql.com/
The options file handling options (like '--defaults-extra-file' and '--defaults-group-suffix') need to come FIRST on the command line.

This isn't really mentioned in the manual (that I noticed), contrary to what this bug report says.
dba  mysql  mysqldump  errormessage  solution 
may 2018 by kme
MySQL :: MySQL 8.0 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program | https://dev.mysql.com/
The "options file handling" options need to come *first* on the command line, otherwise you get an error like what's described in this bug report[1] like "mysql: unknown variable 'defaults-group-suffix=:whatever'"

[1] https://bugs.mysql.com/bug.php?id=19611
dba  sysadmin  mysql  mysqldump  configfile  optionsfile  tipsandtricks  errormessage  solution 
may 2018 by kme
MySQL 5.7.12 import cannot create a JSON value from a string with CHARACTER SET 'binary' - Stack Overflow
For single , double quoting issue reasons you might elect to encode your database dump containing a column containing a column that holds JSON data (MySQL sees this as blob data). Then you might need to import this dump again. In those cases you can decode the hexadecimal strings using the MySQL CONVERT function into the original string with utf8mb4 encoding.This is how you do it.
stackoverflow  mysql  mysql5.7  mysqldump  dump  blob  data  utf8mb4  column  convert  decode  hexadecimal  howto  example  guide  reference 
april 2018 by racl101

« earlier    

related tags

--single-transaction  5.6  admin  advice  all_databases  arguments  aws  back  backup  backupandrecovery  backups  bacula  bash  bashscript  big  blacklocus  blob  blog  blog_db_logica  bottleneck  centos  cli  coding  collation  column  command  commandline  commands  computing  condition  configfile  configuration  cons  convert  copy  corruption  cron  cronjob  crontab  crontask  csv  data  database  databases  dataonly  db  dba  decode  delicious  dev  directories  directory  docker  documentation  dossier  dossiers  dump  dumps  duplicate  duplicity  error  errormessage  example  explained  explanation  export  fast  fichiers  field  file-per-table  files  fix  folder  folders  guide  gz  gzip  hexadecimal  how-to  howto  import  inno  inserts  install  integrity  latin1  limit  limits  linux  load  locking  log  mamp  management  manpage  mariadb  master  myisam  mysql-5.6  mysql  mysql5.7  mysqlclient  mysqldumps  mysqlhotcopy  official  offset  on  only  optimize  options  optionsfile  orderby  out  pager  path  percona  performance  portion  postgres  postgresql  problem  program  pros  rdiff-backup  rds  redo  reference  remote  remotely  replication  restore  safe  sauvegarder  sauvegardes  sbackup  script  scripts  security  seguridad  select  server  serverfault  serveur  settings  sh  shell  shellscript  size  slave  solution  source  split  sql  ssh  stackexchange  stackoverflow  statement  statements  syntax  sysadmin  table  technique  techniques  thisvsthat  tips  tipsandtricks  tolearn  tool  toread  tounderstand  transactional  tricks  troubleshooting  tuning  tutorial  tutorials  ubuntu  unix  utf8  utf8mb4  utility  view  web  webdev  where  without  wordpress  xtrabackup 

Copy this bookmark:



description:


tags: