Plugins/Sidebar on Local Mirror for development and testing

aschlemmer · Post by **aschlemmer** » Fri Apr 20, 2007 10:18 pm

For development and testing purposes, I did a local installation of my blog.

What I did: Using MAMP on OS X, Serendipity installation was fine, as was the template and entries SQL import.

The plugin migration seems to fail. I did a SQL import of the *plugin* tables and a copy of the /plugin/ directory from the live server to my local http-root (sy9 installation default /plugin/ overwritten).

What I get in the admin pane: No plugins visible. After a single try of re-installing a plugin (categories), I get a default view and on the last position, there's a second edition in a correct way. There are also around 4 "Edit" links in the sidebar.

I assume there is some trouble with the plugin management

What's the best way to have a local mirror (with plugins!)?
Thanks for your help in advance![/i]

Post by **garvinhicking** » Sat Apr 21, 2007 2:47 pm

Hi!

If you import SQL tables, always make sure the paths in that table are correct. You will need to fix the paths to suit your local installation.

HTH,
Garvin

aschlemmer · Post by **aschlemmer** » Sat Apr 21, 2007 6:46 pm

Hi, and thanks.

Where do I find the SQL tables' paths?

Thanks
Achim

Post by **garvinhicking** » Sat Apr 21, 2007 6:48 pm

Hi!

The 'path' column in serendipity_plugins.

Regards,
Garvin

aschlemmer · Post by **aschlemmer** » Sat Apr 21, 2007 6:57 pm

Hm, I see there entries like "serendipity_event_karma" or none -- both on the live server and on the local installation.

I have no idea in what to change there for the local installation ... is there a hint for me?

Thanks!
Achim

Update:
Screenshot local installation table:

Screenshot live server installation plugins table:

aschlemmer · Post by **aschlemmer** » Tue Apr 24, 2007 8:37 am

Is there no help for me and my local plugins installation problem?
Which paths are to change for my plugins to work also locally?

Post by **garvinhicking** » Tue Apr 24, 2007 10:00 am

Hi!

Sorry, I was more thinking of the serendipity_pluginlist DB table.

The easiest thing would be to make a full SQL dump of your website and then search for all occurences of the path/URL of your 'real' blog and replace it with the path/url of your 'mirror' blog.

Also make sure that all files are identical on both online and local mirror blog.

HTH,
Garvin

aschlemmer · Post by **aschlemmer** » Tue Apr 24, 2007 10:04 am

OK, thanks -- I'll try that in a few hours. But ... read below:

I tried a full SQL dump first but I get the error that it can't override existing tables (from the local scratch installation) -- do you have a way on how to solve that?

Therefore I deleted table by table and replaced it my a table SQL export ...

A full SQL dump import would ease things massively!

TIA,
Achim from Freiburg

Post by **garvinhicking** » Tue Apr 24, 2007 10:06 am

Hi!

If you re-import a SQL dump you must first drop all existing tables. Or you must make your SQL dump include "DROP TABLE" statements.

phpMyAdmin i.e. supports that DROP TABLE statement in a full export.

Regards,
Garvin

aschlemmer · Post by **aschlemmer** » Tue Apr 24, 2007 10:07 am

Thanks for this lesson

I'll post again when successful.

Have a nice day
Achim

aschlemmer · Post by **aschlemmer** » Mon Apr 30, 2007 9:38 pm

Just as a feedback: using your tips and changing the paths before importing the database locally worked like charm: complete migration done in less than 30 minutes.

Thanks again! Finally, I can develop locally before bringing it on the web.
Great!

Plugins/Sidebar on Local Mirror for development and testing

Plugins/Sidebar on Local Mirror for development and testing

Re: Plugins/Sidebar on Local Mirror for development and test