Jump to content

Recommended Posts

I did a big beginner mistake. I've deleted MAMP PRO to use XAMPP and in the process of the uninstalation of MAMP PRO I deleted all my databases... Fortunately my projects are already live so I have a working copy on the FTP of my client. I would like to have all this data as it is online so it works local on my computer. This is working with a processwire CMS, the url is http://www.fem-k.com/ if in need...

Please let me know how to solve this problem so I can go on playing with processwire on my computer.

Thank you very much!!!

Share this post


Link to post
Share on other sites

Go to phpmyadmin (or whatever there is on your server) and export the PW db. then go to phpmyadmin on xampp and import it.

Share this post


Link to post
Share on other sites

When importing it into XAMPP, remember to first create a database within phpMyAdmin to import it into. Select that database then select import from the menu and do your thing. Otherwise, you will get an error message that database not selected or something to that effect. You also will want to create a database with the same collation as the one online.

Share this post


Link to post
Share on other sites

When importing it into XAMPP, remember to first create a database within phpMyAdmin to import it into. Select that database then select import from the menu and do your thing. Otherwise, you will get an error message that database not selected or something to that effect. You also will want to create a database with the same collation as the one on online.

Thank you for the replies! What do you mean with "create with the same collation". I do not understand collation in this context.

Share this post


Link to post
Share on other sites

You can set this when creating the new db. It's most likely 'utf8_general_ci'...

Also make sure that $config->userAuthSalt in /site/config.php has the same value as on your server.

But you're probably downloading your Pw files from the ftp anyway, so this won't be a problem.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By DooM
      Hello guys,
      I'm trying to figure out how to sync fields and templates between staging and production environments.
      I've found Migrations module by Lostkobrakai, but with use of it all the fields and templates must be created by API, which is kind of uncomfortable.
      I also tried ProcessDatabaseBackups module which can export only certain tables, but I don't think it's the best practice to do that.
      How do you guys solve this problem? It's very annoying to setup everything three times (dev, staging, production).
      Thanks a lot :)
    • By iipa
      Hi everybody!
      I have been reading about Multisite, but it kinda bugs me that every topic talks about having both admin and database same for multiple sites.
      I have a project where customer tests it by adding content to the site, while I still need to do some changes here and there in code, maybe some in database. If something crashes for a while, customer can't keep testing, which is a bit problematic.
      Is there any way that I could have two separate versions of one site ("production" and development) that share the same database, but are otherwise independent? Just the thought of having to migrate database every time I want to show client something new gives me anxiety 😁
    • By modifiedcontent
      I had upgraded my Apache configuration to include PHP7.2 and PHP7.3 for a Laravel-based script on the same server. Somehow it/I messed up a previously fine Processwire site, in a very confusing way.
      The site still looks fine, but editing template files has no effect whatsoever. It is stuck on some kind of cached version. I have already disabled PHP7's OPcache, cleared browser caches, etc, with no effect.
      The pages now apparently come from PW's assets/cache/FileCompiler folder, even though I never enabled template caching for this site.
      I have tried adding "namespace ProcessWire;" to the top of the homepage template file, but then I get this fatal error:
      My functions.php file pulls data in from another Processwire installation on the same VPS with the following line:
      $othersitedata = new ProcessWire('/home/myaccount/public_html/myothersite/site/', 'https://myothersite.com/'); That apparently still works fine; the site still displays data from the other installation, but via the "cached" template that I am now unable to change.
       
      I don't know where to start with this mess. Does any of this sound familiar to anyone? Any pointers in the right direction would be much appreciated. 
       
      Edit:
      Adding "$config->templateCompile = false;" to config.php results in the same fatal error as above. 
    • By Brawlz
      Hi,
      I hope this is the correct section for my problem.
      All I need is a connection to an external Database and a query gettings some data. I do this in a processwire Page-Template. I am honestly not sure if it is a problem with processwire or my code:
      $host = ‚XXXXX’; $user = ‚XXXXX‘; $pass = ‚XXXXX‘; $db = ‚XXXXX‘; $port = ‚3306‘; $mydb = new Database($host, $user, $pass, $db , $port);  $result = $mydb->query("SELECT * FROM char“);  while($row = $result->fetch_assoc()) {  print_r($row);  }  
      Produces the following error:
      Error: Exception: DB connect error 2002 - Connection timed out (in /customers/9/4/e/XXXX.de/httpd.www/wire/core/Database.php line 79)
       
      I also tried connecting without the $port variable but got the same error.
×
×
  • Create New...