@Hiker

Ist es #MySQL oder #MariaDB?

Zumindest bei #MyISAM sollte auch via #SQL ein #OPTIMIZE funktionieren...

@feb @zwovierzwo

I now run #mariadb with

--optimizer-use-condition-selectivity=1 --optimizer-switch='rowid_filter=off' --innodb-buffer-pool-size=6G --query-cache-size=64M --max-heap-table-size=64M --tmp-table-size=64M

That helps a lot overall, but the personal page is still about 8 to 10 times slower than everything else.

The creation of th DB apparently worked as expected.

The problem I now ran into is that I can't upload the backup sql DB I donwloaded from the old hosting.

I did this using the hints of the following stackoverflow description:
importing-a-database-using-ssh
but somehow this doesn't work.

I created a folder in my home directory for to log into the VPS via ssh where I placed the privkey.pem and the backupname.sql

This is the command sequence I execute:
cd hostingfolder
/hostingfolder ssh -i privkey.pem rootname@00.000.00.000
Enter passphrase for key 'privkey.pem':
Welcome to Ubuntu ..
..
rootname@ubuntu:~# mysql -u friendica@localhost -ppassword friendicadb < backupname.sql

The response by the server is:
-bash: backupname.sql: No such file or directory

I also tried:
rootname@ubuntu:~# mysql -u friendica -ppassword friendicadb < backupname.sql
with the same result

Of course the file backupname.sql does exist and is located in /hostingfolder
I also copied it to the folder /home/username/ just to make sure.

I searched for the error message and found:
stackoverflow | remote mysql import no such file or directory

so I tried:
mysql -u 'friendica'@'localhost' -ppassword friendicadb < '/home/username/hostingfolder/backupname.sql'
and
mysql -u 'friendica'@'localhost' -ppassword friendicadb < "/home/username/backupname.sql"
but that didn't do the trick either.

Any ideas?

#fediHelp #mysql #mariadb #ssh #linux