Serendipity Forums

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]

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

Hi, and thanks.

Where do I find the SQL tables' paths?

Thanks
Achim

Hi!

The 'path' column in serendipity_plugins.

Regards,
Garvin

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:

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

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

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

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

Thanks for this lesson

I'll post again when successful.

Have a nice day
Achim

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!