Zymic Forums

Webmaster resources

Zymic IRC Server

Chat in real time at irc.zymic.com - Learn More

Welcome

Welcome to the Zymic webmaster forums. Our forums are here to provide people the free ability to discuss a range of websites related topics such as design, development coding and marketing.

In order to post you will need to register for a zymic account or if you already have one simply login by using the form on the left.

left Zymic Webmaster ForumsZymic Free Web HostingDatabases & MySQL right
  Reply to this topic Start new topic
left right
DaSpirit
post May 26 2009, 10:12 PM
Post #1


Newbie
*

Group: Members
Posts: 14
Joined: 20-January 09
Member No.: 78,384



Hi, I'm wondering is it possible to back up Databases, just in case anything happens? I tried searching for it but nobody got their question answered.
Go to the top of the page 
 
  + Quote Post
swordz
post May 26 2009, 11:10 PM
Post #2


Outrageously Uber Ninja
*******

Group: Moderators
Posts: 1,740
Joined: 10-July 08
From: UK
Member No.: 44,994



PHPMyAdmin -> export.

swordz
Go to the top of the page 
 
  + Quote Post
ArticleMaster
post May 27 2009, 05:41 AM
Post #3


Newbie
*

Group: Members
Posts: 28
Joined: 8-May 09
Member No.: 94,269



You can use mysqldump to create a simple backup of your database using the following syntax which is elaborated below.

QUOTE
mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

[username] - this is your database username
[password] - this is the password for your database
[databasename] - the name of your database
[backupfile.sql] - the file to which the backup should be written.
Go to the top of the page 
 
  + Quote Post
swordz
post May 27 2009, 09:21 AM
Post #4


Outrageously Uber Ninja
*******

Group: Moderators
Posts: 1,740
Joined: 10-July 08
From: UK
Member No.: 44,994



That requires ssh access, which you don't have.

swordz
Go to the top of the page 
 
  + Quote Post
Jimm
post Jun 19 2009, 11:49 AM
Post #5


Newbie
*

Group: Members
Posts: 2
Joined: 22-April 09
Member No.: 92,222



QUOTE(swordz @ May 26 2009, 11:10 PM) *
PHPMyAdmin -> export.

swordz


Are there any specific options we need to check, or is it just a simple "Export -> Select database -> OK" ?
Go to the top of the page 
 
  + Quote Post
 Reply to this topic Start new topic
left right
0 Members:
left right
 


Lo-Fi Version Time is now: 21st November 2009 - 10:18 AM