| === led_dark_2 is now known as led_dark_1 | ||
| mike802 | hi, i'm trying to run the command cat wordpress.sql | sudo mysql --default-extra-file=/etc/mysql/debian.cnf | 17:35 |
|---|---|---|
| mike802 | and i'm getting ERROR at line 1: Unknown command '\b' | 17:36 |
| mike802 | i can't find any typos in the files that the wordpress section of the ubuntu server guide had me type up, but i'll keep looking | 17:37 |
| tomreyn | \b is a backspace | 17:39 |
| RoyK | perl -pe 's/\b//g' -i file.cnf | 17:40 |
| tomreyn | mike802: when you run head -n2 wordpress.sql does this output contain any sensitive content, anything you could not share with us? | 17:41 |
| mike802 | it's all sql statements, create database etc | 17:41 |
| tomreyn | mike802: on those 2 lines? | 17:41 |
| RoyK | there shouldn't be \b in an sql file | 17:42 |
| tomreyn | anyways, it doesn'T answer my question. | 17:42 |
| mike802 | well, when i saved the file the system asked me to create an encryption key | 17:42 |
| mike802 | which i have to type in to open the file | 17:42 |
| RoyK | mike802: did you try the perl command above? make a backup first | 17:42 |
| tomreyn | what's the output of "file wordpress.sql" | 17:42 |
| mike802 | brb | 17:42 |
| tomreyn | RoyK: not a good idea if it's encrypted | 17:43 |
| tomreyn | (but yeah, backup.) | 17:43 |
| RoyK | tomreyn: indeed | 17:43 |
| RoyK | tomreyn: but perhaps it's just gzipped or something and has the wrong extension | 17:43 |
| mike802 | the head -n2 command just returns encrypted characters | 17:43 |
| mike802 | :x | 17:44 |
| RoyK | what did 'file' say? | 17:44 |
| RoyK | (what does the fox say) | 17:44 |
| mike802 | puttyputty | 17:44 |
| mike802 | ::::|||~~~~~ putty putty | 17:44 |
| tomreyn | mike802: well if the sql file is encrypted then you can't just feed it into the mysql command like this | 17:45 |
| mike802 | oh, weird. i'll try deleting and making a new one | 17:45 |
| tomreyn | you'll need to find out how to decrypt it on the shell. | 17:45 |
| tomreyn | or export it unencrypted where it comes from | 17:45 |
| mike802 | i'm just gonna ctrl+c the key bit | 17:45 |
| RoyK | mike802: if it's encrypted, the backup job must have done that | 17:46 |
| mike802 | i'm typing this up from the ubuntu server guide web page | 17:46 |
| mike802 | https://help.ubuntu.com/lts/serverguide/wordpress.html.en | 17:46 |
| mike802 | awesome, thank you | 17:49 |
| mike802 | weird | 17:49 |
| muhaha | How do I run systemctl --user enable pulseaudio && systemctl --user start pulseaudio under root? It does not work for root , I need to run in userspace. (Failed to connect to bus: No such file or directory) | 17:52 |
| muhaha | nvm, it should be started under user | 17:59 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!