I have a database from my old pc I'd like to import to my NAS. I have the db in raw mysql format (.frm, .myd, .myi) and I'd like to be able to put them in the mysql database folder on my NAS.
How can I do this?
Any help would be appreciated
MYSQL database backup
Forum rules
This is a user forum for Synology users to share experience/help out each other: if you need direct assistance from the Synology technical support team, please use the following form:
https://myds.synology.com/support/suppo ... p?lang=enu
This is a user forum for Synology users to share experience/help out each other: if you need direct assistance from the Synology technical support team, please use the following form:
https://myds.synology.com/support/suppo ... p?lang=enu
4 posts
• Page 1 of 1
MYSQL database backup
by Gabiru » Tue Jun 05, 2012 10:55 pm
Hi guys,
I have a database from my old pc I'd like to import to my NAS. I have the db in raw mysql format (.frm, .myd, .myi) and I'd like to be able to put them in the mysql database folder on my NAS.
How can I do this?
Any help would be appreciated
I have a database from my old pc I'd like to import to my NAS. I have the db in raw mysql format (.frm, .myd, .myi) and I'd like to be able to put them in the mysql database folder on my NAS.
How can I do this?
Any help would be appreciated
- Gabiru
- Beginner
- Posts: 22
- Joined: Sat Nov 19, 2011 3:13 pm
Re: MYSQL database backup
by mike42dk » Wed Jun 06, 2012 4:31 pm
Hi
Go to Package center in the Start menu, install phpMyAdmin, run it, and then log in with root and no password (blank) first time, make a new password, and from phpMyAdmin you can install databases
Go to Package center in the Start menu, install phpMyAdmin, run it, and then log in with root and no password (blank) first time, make a new password, and from phpMyAdmin you can install databases
Regards Michael
###############################################
Synology DS-412+ with DSM 4.2 3211
Westen Digital 20EFRX 2 TB. in slot 1 (format to EXT4) Basic
Seagate ST2000DL003 2 TB. in slot 2 (format to EXT4) Basic
Samsung USB2 G3 Station 2 TB. (format to EXT4)
Please don't PM for help, use forum so all users can see answers
###############################################
Synology DS-412+ with DSM 4.2 3211
Westen Digital 20EFRX 2 TB. in slot 1 (format to EXT4) Basic
Seagate ST2000DL003 2 TB. in slot 2 (format to EXT4) Basic
Samsung USB2 G3 Station 2 TB. (format to EXT4)
Please don't PM for help, use forum so all users can see answers
-
mike42dk - g33k
- Posts: 1897
- Joined: Sun Jun 06, 2010 7:45 am
- Location: Denmark
Re: MYSQL database backup
by HarryPotter » Wed Jun 06, 2012 5:25 pm
AFAIK phpmyadmin doesnt give you the possibility to install DB data in raw format. You have to do that on the CLI. Refer to the MySQL commands how to this. It is not really Synology related.
*Please do not Private Message me for support questions; leave it on the forum so all members can learn. Thanks!*
DS712+ / DSM 4.2 3211 / 2 x HD204UI (RAID0) / LMS 7.7.2-007
DS110+ / DSM 4.2 3211 / HD154UI
DS408 / DSM 4.0 2228 / 3 x ST31000340AS (RAID0) + 1 x HDS721010KLA330
DS207+ / DSM 3.1.1636 / ST31000340AS + WD5000KS
DS-106x / DSM 4.0 2228 (from DS108j) /
2 Squeezebox 3 + Boom
Rapsody N35
APC Smart UPS SUA750i
DS712+ / DSM 4.2 3211 / 2 x HD204UI (RAID0) / LMS 7.7.2-007
DS110+ / DSM 4.2 3211 / HD154UI
DS408 / DSM 4.0 2228 / 3 x ST31000340AS (RAID0) + 1 x HDS721010KLA330
DS207+ / DSM 3.1.1636 / ST31000340AS + WD5000KS
DS-106x / DSM 4.0 2228 (from DS108j) /
2 Squeezebox 3 + Boom
Rapsody N35
APC Smart UPS SUA750i
-
HarryPotter - Honorary Moderator
- Posts: 12393
- Joined: Mon Oct 23, 2006 12:48 pm
- Location: Switzerland
Re: MYSQL database backup
by mutterburra » Sat Jun 23, 2012 11:20 am
I've noticed phpAdmin only allows an export to the machine the browser is running on, are there any tips anywhere on exporting it to a NAS folder (and thus automatically back it up to an external drive) I assume this means diving into the terminal and mysqling away at the prompt.
- mutterburra
- I'm New!
- Posts: 3
- Joined: Sat Jun 23, 2012 8:37 am
4 posts
• Page 1 of 1
Return to Web Server + PHP / MySQL
Who is online
Users browsing this forum: No registered users and 4 guests