Archive since 2000
This section first appeared on my website more than twenty years ago.
They were small tricks, commands and notes we kept so we wouldn't have to look them up again: Unix, Linux, C, Apache, Informix and anything else I was tinkering with at the time.
I've recovered that archive almost exactly as it was. Many of these tips are old, some very old, and should be read as part of this website's history, not necessarily as current technical advice.
70 tips · since 2000
Bases Datos / Informix
In Spanishdbschema -d base_datos [-t tabla] > nombre_fichero
macgollum · 14 MAR 2001
ArchiveBases Datos / Informix
In Spanishgrant base_datos to 'usuario'
macgollum · 14 MAR 2001
ArchiveBases Datos / Informix
In Spanishset explain on;
macgollum · 14 MAR 2001
ArchiveBases Datos / Informix
In Spanishdrop index nombre_indice;
macgollum · 14 MAR 2001
ArchiveBases Datos / Informix
In Spanishcreate [unique] index nombre_indice on tabla (campo1, campo2...);
macgollum · 14 MAR 2001
ArchiveBases Datos / Informix
In Spanishload from nombre_fichero insert into tabla;
macgollum · 14 MAR 2001
ArchiveBases Datos / Informix
In Spanishunload to nombre_fichero select * from tabla;
macgollum · 14 MAR 2001
ArchiveBases Datos / MySQL
In Spanishpara exportar : mysqldump -u root -p -d nombrebasedatos > basedatos.dump -d exporta sin datos (solo estructura) para importar : añadir a basedatos.dump al principio la linea use nombrebasedatos ; y luego hacer .... mysql -u root -p <…
CoffMan · 13 DEC 2000
Archive