Welcome to Geeklog, Anonymous Tuesday, November 10 2026 @ 08:20 pm EST
Geeklog Forums
Backing up a single story
Hello,
I currently have two servers, and migrated my geeklog site from one to the other, but in the time it took for my domain to transfer to the new nameservers, 5 stories were posted. I would like to put those stories onto my new server, without making a complete backup as it would erase the new content on my new server.
How do I backup certain targeted stories, copy them from phpMyAdmin or whatever to a file, and then upload that onto my other server via phpMyAdmin.
Thanks in advance
I currently have two servers, and migrated my geeklog site from one to the other, but in the time it took for my domain to transfer to the new nameservers, 5 stories were posted. I would like to put those stories onto my new server, without making a complete backup as it would erase the new content on my new server.
How do I backup certain targeted stories, copy them from phpMyAdmin or whatever to a file, and then upload that onto my other server via phpMyAdmin.
Thanks in advance
14
16
Quote
Status: Banned
machinari
Forum User
Full Member
Registered: 03/22/04
Posts: 1512
couple options open to you...
phpmyadmin has a nifty little function called "export" that you can see as a tab near the top of your page. use that to export/backup a single table (the gl_stories table). Do not check "add drop table"! There should be an option to "dump [somenumber] amount of rows starting at record number [somenumber]" and then use that backup to insert rows into your new stories table in your new db.
it backs up only the rows after your specified row (the 6th lst one) and is ready set to be sent to the phpmyadmin-sql-tab of your new database.
hope that gives you a starting place.
phpmyadmin has a nifty little function called "export" that you can see as a tab near the top of your page. use that to export/backup a single table (the gl_stories table). Do not check "add drop table"! There should be an option to "dump [somenumber] amount of rows starting at record number [somenumber]" and then use that backup to insert rows into your new stories table in your new db.
it backs up only the rows after your specified row (the 6th lst one) and is ready set to be sent to the phpmyadmin-sql-tab of your new database.
hope that gives you a starting place.
38
16
Quote
All times are EST. The time is now 08:20 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content