Categories

· Show all categories

· New Customer FAQs
· E-Mail
· FTP - File Transfers
· Domains
· SSH and Telnet
· Scripting Languages
· Password Protection
· MySQL
· Stats
· Power Tools

· FAQ Home

· EchoEcho+ Support

XML-File

<?xml version="1.0" encoding="iso-8859-1"
standalone="yes" ?>
<!-- XML-Output by phpMyFAQ 1.3.8 -->
<phpmyfaq
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:NamespaceSchemaLocation="http://www.phpmyfaq.de/xml/faqschema.xsd">
<article id="34">
	<language>en</language>
	<category>MySQL</category>
	<keywords></keywords>
	<theme>How do I restore a backup of a
database?</theme>
	<content
xmlns="http://www.w3.org/TR/REC-html40">You can restore a backup of a
database created with
mysqldump *.

1: Create the database with the site owner panel 
- The ONLY way you can create databases is from the site
owner panel, so
you must create the database first.
- If it already exists, delete it, and create it again to
make sure
it&#039;s empty before the restore.
2: Log in to the server via <a
href="http://www.pro.echoechoplus.com/helpfiles/index.php?&amp;aktion=anzeigen&amp;rubrik=005"
target="_blank">SSH </a>.
3: Write a command like this (directly at the SSH prompt):

<b>mysql -u username -h localhost -p databasename &lt;
textfile</b>

- <b>username</b> is the username for your hosting plan, for
example:
testuser.
- <b>databasename</b> is the name of your database, for
example:
testuser_mybase.
- <b>textfile</b> is the name of the backup file, for
example:
backup_mybase.

4: You will be asked for your password. Enter the mysql
password for the
database.

That&#039;s it - mysql will now read the backup file and
create and restore
your database tables!



* The backup procedure is explained here: <a
href="/helpfiles/index.php?aktion=artikel&amp;rubrik=019&amp;id=33&amp;lang=en">How
do I create a backup of a database?
</a></content>
	<author>EchoEcho Support</author>
	<date>12.07.2009, 21:19</date>
</article>
</phpmyfaq>

open XML-File