So I can modify databases when they are stored in local client (HOW-TO:Update_SQL_databases_when_files_move (wiki))
But how I do the same when they are on a mysql server (let’s say ubuntu). Right now I can see the below. I see information_schema database is created always. I have defined ‘<name>Videos-main</name>’, so I guess this is why
I get a different database with this name.
Can I just delete folders if I have to, like I would with .db files? How can I easily edit the contents of the database (like I would do with .db files if I have to change the paths)
———–
mysql> show databases
-> ;
+——————–+
| Database |
+——————–+
| information_schema |
| Music-main56 |
| MyMusic56 |
| MyVideos99 |
| Videos-main99 |
| mysql |
| performance_schema |
| sys |
+——————–+
8 rows in set (0.00 sec)
mysql> exit
Bye
root@odroid:~# ls -la
total 180
drwx—— 13 root root 4096 Feb 26 10:19 .
drwxr-xr-x 22 root root 4096 Feb 19 19:08 ..
-rw——- 1 root root 32657 Feb 19 19:08 .bash_history
-rw-r–r– 1 root root 3106 Oct 22 2015 .bashrc
drwx—— 5 root root 4096 Nov 6 19:29 .cache
drwx—— 10 root root 4096 Jan 7 15:43 .config
drwxr-xr-x 2 root root 4096 Nov 3 19:11 Desktop
drwx—— 3 root root 4096 Nov 3 19:20 Downloads
-rw-r–r– 1 root root 14 Nov 11 11:51 fan_mode~
-rw-r–r– 1 root root 16 Nov 11 12:05 fan_modz~
drwxr-xr-x 9 root root 4096 Jan 8 11:33 .kodi
-rw-r–r– 1 root root 35592 Jan 1 19:50 kodi_crashlog-20170101_195041.log
-rw-r–r– 1 root root 38196 Jan 1 19:51 kodi_crashlog-20170101_195134.log
drwxr-xr-x 3 root root 4096 Nov 3 19:14 .local
drwx—— 4 root root 4096 Nov 3 19:11 .mozilla
-rw——- 1 root root 594 Feb 26 10:19 .mysql_history
drwxr-xr-x 2 root root 4096 Nov 14 01:08 .nano
drwx—— 3 root root 4096 Jul 5 2016 .pki
-rw-r–r– 1 root root 148 Aug 17 2015 .profile
drwx—— 2 root root 4096 Nov 5 09:40 .psensor
drwx—— 2 root root 4096 Jul 5 2016 .ssh
root@odroid:~#
——————-