Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: ber on March 18, 2009, 01:07:29 PM

Title: Mysqldump database restore for a newbie!
Post by: ber on March 18, 2009, 01:07:29 PM

 :smile:Hi all ive began using my SME server to host some of my clients websites. Most were pretty basic until i came across one with a mysql database. I transferred the database to my SME 7.4 server and the previous hosts sent me the website files and also a mysqldump file. Being a newbie and having little understanding about databases i simply copied the website files into the html folder and then switched it online. Two days later i got some complaints from the client saying that they could not access certain links on the website and were not able to update it? I found out that there was a mysql database for the website and wasn't configured or installed.
It makes sense that the previous host has sent me a backup of the mysql database and would have to setup this database in order for the website to work properly.
My question is - how do i do this?
What is the process to "restore" the database from the "mysqldump" file that ive been sent.?
Thanks already for any replies and will be more than happy to forward more info if you require it.

Title: Re: Mysqldump database restore for a newbie!
Post by: dadoudidon on March 18, 2009, 01:17:47 PM

try to do the dump using phpmyadmin
http://wiki.contribs.org/PHPMyAdmin

david

Title: Re: Mysqldump database restore for a newbie!
Post by: cactus on March 18, 2009, 09:32:02 PM

The most basic command on SME Server would be:

Code: [Select]

mysql < /path/to/dump/file.sql
However you might run into problems for instance the database needs to be created first:

Code: [Select]

mysqladmin create database databasename
You also need to (re)configure the account which is used for the webpages to connect to your mysql services, more information is in the wiki: http://wiki.contribs.org/MySQL

Another extensive and very good source of documentation is the MySQL manual itself, which is hosted online on the MySQL website, for your convenience: http://dev.mysql.com/doc/refman/4.1/en/ (for the version on SME Server), and a few relevant sections in your case:

MySQLadmin: http://dev.mysql.com/doc/refman/4.1/en/mysqladmin.html
MySQL User account management: http://dev.mysql.com/doc/refman/4.1/en/user-account-management.html

Furthermore a lot about MySQL can be found by using google as well and if you do not now an answer concerning MySQL and SME Server you can always come back to these forums and ask again.

One peace of advice is to read the wiki on MySQL on SME Server as this contains some information on how you can access MySQL on SME Server, this is a bit easier than on most MySQL systems, especially for the root user.

Title: Re: Mysqldump database restore for a newbie!
Post by: ber on March 19, 2009, 02:23:28 AM

Hi cactus, thank you very much for the info- found it really helpful, especially the GUI for phpmyadmin- great for us newbies. great contrib- simple and powerful. :smile:
PS... Cactus? like prickly cactus- whats the connection? :lol:

regards John

Title: Re: Mysqldump database restore for a newbie!
Post by: cactus on March 19, 2009, 12:48:31 PM

Quote from: ber on March 19, 2009, 02:23:28 AM

PS... Cactus? like prickly cactus- whats the connection? :lol:

My haircut...

Title: Re: Mysqldump database restore for a newbie!
Post by: electroman00 on March 20, 2009, 11:22:36 AM

Mysqldumper works a treat also.

http://www.mysqldumper.de/en/ (http://www.mysqldumper.de/en/)