https://legacy.forums.gravityhelp.com/topic/moving-day-take-your-entries-and-move-them-to-your-new-db Gravity Support Forums Topic: Moving day - take your entries and move them to your new db en-US Sun, 19 Apr 2026 22:23:57 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/moving-day-take-your-entries-and-move-them-to-your-new-db#post-43656 Sat, 10 Dec 2011 15:38:18 +0000 Chris Hajer 43656@https://legacy.forums.gravityhelp.com/ <p>Thank you mtbethel for posting your experience. </p> https://legacy.forums.gravityhelp.com/topic/moving-day-take-your-entries-and-move-them-to-your-new-db#post-43632 Sat, 10 Dec 2011 12:40:35 +0000 Cliff Seal 43632@https://legacy.forums.gravityhelp.com/ <p>I can confirm that this works. In my case, I needed to export rg_lead, re_lead_detail, rg_lead_detail_long, rg_lead_meta, and rg_lead_notes. Make sure you make backups though—it took me several tries to get it just right using Sequel Pro. </p> https://legacy.forums.gravityhelp.com/topic/moving-day-take-your-entries-and-move-them-to-your-new-db#post-35723 Tue, 20 Sep 2011 00:27:00 +0000 Chris Hajer 35723@https://legacy.forums.gravityhelp.com/ <p>How nice to see this as my last unread post of the evening. Thanks for posting your experience. I'll make sure the rest of the team sees this. </p> https://legacy.forums.gravityhelp.com/topic/moving-day-take-your-entries-and-move-them-to-your-new-db#post-35709 Mon, 19 Sep 2011 22:20:55 +0000 eyecool 35709@https://legacy.forums.gravityhelp.com/ <p>This isn't a question, problem or bug. This is a BIG thank YOU to the Rocket Genius team for being awesome. It is because they are awesome that their product is awesome.</p> <p>Why the love? Well, I rarely get to post on here because:</p> <ol> <li>The Gravity Forms documentation is very thorough. </li> <li>The code is extremely well written - take the time to read it. It will talk to you. </li> <li>The handfull of times I've had a question, I've searched this very forum and found the answer. </li> </ol> <p>Today, I had a question. A big one. How can I copy entries on from my massively complex, multisite, multinetwork, multiserver environment to my sorta complicated, multisite, single server development environment.</p> <p>Chances are just about any question you can have has already been answered on here, several times. But what if you are running multiple layers of nginx that connect to isolated php-fpm servers and all of these connect to each other using sockets over a private lan! And the standalone mysql server is firewalled harder than 'The Great Firewall of China'!!?? Then what do you do? Ask the question anyway? </p> <p>"No!" I say. Read the code, else if, search the forum, else if, refer back to the documentation. If all else fails, then submit a query. So that's what I did.</p> <p>Turns out the venerable Carl Hancock answered the question in another post. (and I used pencil and paper to make notes in my $2, college ruled notebook labeled 'Server'). The note reads:<br /> "Entry data goes into rg_lead, re_lead_detail &amp; rg_lead_detail_long tables. They are stored across multiple tables to for max performance"</p> <p>Long story short (lol), it just works. I exported the 3 tables to a single .sql file. Then exported the .sql file to the new server. If you're on a single site, you're done. If you're on multisite change the #(id) of your table to match the #(id) of the site in the receiving (new) db. **Remember to set your form up before messing around with the db**</p> <p>My one advice is; don't use phpMyAdmin. You'll avoid a wide variety of headaches, present-past-and-future by using open source apps made for maintaining mysql databases. Look at <a href="http://www.mysql.com/downloads/workbench/" rel="nofollow">http://www.mysql.com/downloads/workbench/</a> It is OS agnostic. It may not come easy, it may take some time, but get it configured and working. Use google to find alternatives for your OS. I use OS X, and sometimes use Sequel Pro (free) for quick stuff.</p> <p>Ciao! Thank you! And have fun taking your entries wherever you may roam!</p> <p>*edit - changed 2nd paragraph to an ordered list for presentation </p>