Restore MYSQL database from MYSQL files
> cd TO_BACKUP_FILES_DIRECTORY
> cp ib* /var/lib/mysql/
> cp --recursive /home/42406/var/lib/mysql/mariomansion /var/lib/mysql/.
If you have root access to the server, you should be able to put the files there yourself; I assume you have root access if you installed a LAMP stack. If not, you may need to get customer support to do that for you.
The owner and group for the directories and their files when placed there should be mysql. You can change the ownership with the following commands if you can copy the directory and its files there.
> chown --recursive mysql /var/lib/mysql/*
> chgrp --recursive mysql /var/lib/mysql/*
> service mysqld restart
> cp ib* /var/lib/mysql/
> cp --recursive /home/42406/var/lib/mysql/mariomansion /var/lib/mysql/.
If you have root access to the server, you should be able to put the files there yourself; I assume you have root access if you installed a LAMP stack. If not, you may need to get customer support to do that for you.
The owner and group for the directories and their files when placed there should be mysql. You can change the ownership with the following commands if you can copy the directory and its files there.
> chown --recursive mysql /var/lib/mysql/*
> chgrp --recursive mysql /var/lib/mysql/*
> service mysqld restart
Comments
Post a Comment