Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
rss_admin_db_manager: local server
Hey all, I recently set up a local environment to work on a site of mine, and I am having some difficulties with my genius plan that I had in mind!
I have TXP running locally, and on a live server. I installed a fresh copy locally along with the rss_admin_db_manager. I thought I could just make a backup from the live server, and restore on the local to get an exact copy of the current live site. This however does not work, and the rss_admin_db_manager throws an error that says – “FAILED TO RESTORE: 127”.
Anyone maybe know why this would be? This worked perfectly for me when I changed hosts, but going locally does not seem to work. Is there a way that I can replicate my live server site on my local machine easily? I thought this would work, but it did not. Any ideas? Thanks!
(Edit: updated discussion topic. -Mary)
Last edited by Mary (2007-04-16 23:54:08)
Offline
#2 2007-04-16 23:57:39
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: rss_admin_db_manager: local server
Assuming you are on Windows: it would be because you don’t have a full path entered to your MySQL executables in the plugin’s prefs and you also don’t have their path entered in your system’s environment variables.
All you need to do is update either one. I’d recommend just putting the full paths into the plugin’s prefs. For example: I have MySQL located at C:\webdev\mysql\bin\mysql.exe, so I’d replace mysql with that full path. Same thing for mysqldump.
Offline
Re: rss_admin_db_manager: local server
I am using MAMP on OSX for my local environment.
TXP is installed in Applications/MAMP/htdocs/
MySQL is in Applications/MAMP/db/mysql <——Inside there is a folder for my database.
Is this the file path that I need to point to?
Offline
#4 2007-04-17 00:49:29
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: rss_admin_db_manager: local server
No, it needs to point to the executable file. On Windows that’s anything *.exe, I don’t know what the equivalent would be for OSX. Would any Mac users chime in here, please?
Offline
Re: rss_admin_db_manager: local server
I’ve never used rss_admin_db_manager locally, but I’d guess the path needs to be /Applications/MAMP/db/mysql/mysql (or /Applications/MAMP/local/mysql/bin/mysql (extensionless file) if available). I installed MySQL and PHP manually, so I’m afraid I’m not much help.
BTW, you should totally be using CocoaMySQL for db management. No problems with that for backing up and restoring (though you need to specify a socket for MAMP).
Offline
#6 2008-05-05 23:10:54
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,306
Re: rss_admin_db_manager: local server
Just found out the correct settings for MAMP (thanks to Jon-Michael!):
mysqldump Path:
/Applications/MAMP/Library/bin/mysqldump
mysql Path:
/Applications/MAMP/Library/bin/mysql
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline