Help converting database

Started by rodriguesp, October 09, 2011, 08:58:34 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.


thanks guys.
will try that and give feedback.


just to add don't forget to save your old torrent files from your old database and put them in your new one.I would also recommend you comment out your old clean torrents in your cleanup.php until everything is done and all of the torrents have seeders before you enable it.Just a recommendation


Export all data from the needed tables without structure from V1 and import it into the new database in V2.

If you have something in ex. torrents, which aren't in the new torrents, then export needed tables with structures and data from V1 and import it to a temp. database.  Remove the things that you don't have in V2 and then export data from this temp. database and import to V2.

Always have a backup before doing this.
You should be able to do this with torrents, users, snatched etc.


export the sql file and open it via notepad and you get a output something like:

INSERT INTO `users` (`id`, `username`, `passhash`, `secret`, `passkey`, `email`, `status`, `added`, `last_login`, `last_access`, `curr_ann_last_check`, `curr_ann_id`, `editsecret`, `privacy`, `stylesheet`, `info`, `acceptpms`, `ip`, `class`, `override_class`, `language`, `avatar`, `av_w`, `av_h`, `uploaded`, `downloaded`, `title`, `country`, `notifs`, `modcomment`, `enabled`, `donor`, `warned`, `torrentsperpage`, `topicsperpage`, `postsperpage`, `deletepms`, `savepms`, `reputation`, `time_offset`, `dst_in_use`, `auto_correct_dst`, `show_shout`, `shoutboxbg`, `chatpost`, `smile_until`, `seedbonus`, `bonuscomment`, `vip_added`, `vip_until`, `freeslots`, `free_switch`, `invites`, `invitedby`, `invite_rights`, `anonymous`, `uploadpos`, `forumpost`, `downloadpos`, `immunity`, `leechwarn`, `disable_reason`, `clear_new_tag_manually`, `last_browse`, `sig_w`, `sig_h`, `signatures`, `signature`, `forum_access`, `highspeed`, `hnrwarn`, `hit_and_run_total`, `donoruntil`, `donated`, `total_donated`, `vipclass_before`, `parked`, `passhint`, `hintanswer`, `avatarpos`, `support`, `supportfor`, `sendpmpos`, `invitedate`, `invitees`, `invite_on`, `subscription_pm`, `gender`, `anonymous_until`, `viewscloud`, `tenpercent`, `avatars`, `offavatar`, `pirate`, `king`, `hidecur`, `ssluse`, `signature_post`, `forum_post`, `avatar_rights`, `offensive_avatar`, `view_offensive_avatar`, `paranoia`, `google_talk`, `msn`, `aim`, `yahoo`, `website`, `icq`, `show_email`, `parked_until`, `gotgift`, `hash1`, `suspended`, `bjwins`, `bjlosses`, `warn_reason`, `onirc`, `irctotal`, `birthday`, `got_blocks`, `last_access_numb`, `onlinetime`, `pm_on_delete`, `commentpm`) VALUES
(1, 'System', 'fc19749bd8439b156634375d0400af4d', 'QI.^H', '352f54e0ab13da7bdab9c5c355dbacb0', '', 'confirmed', 1315686586, 1318104498, 1318125342, 1318125342, 0, '', 'normal', 17, NULL, 'yes', '', 6, 255, 'en', '', 100, 86, 0, 0, '', 0, '', '', 'yes', 'no', 0, 0, 0, 0, 'yes', 'no', 10, '0', 1, 1, 'yes', '1', 1, 0, '274.2', NULL, 'no', 0, 5, 0, 1, 0, 'yes', 'no', 1, 1, 1, 0, 0, '', 'no', 1318125344, 0, 0, 'yes', '', 1318122635, 'no', 'no', 0, 0, 0, '0.00', 0, 'no', 1, 'b16d2bc5f4c913134a9c2ba0bbc086ad', 1, 'no', '', 1, 0, '', 'yes', 'no', 'Male', 0, 'yes', 'no', 'yes', 'no', 0, 0, 'no', 1, 'yes', 'yes', 'yes', 'no', 'yes', 0, '', '', '', '', '', '', 'no', 0, 'no', '', 'no', 0, 0, '', 'no', 0, '1992-09-28', 'no', 1318125342, 27105, 'no', 'no');

and you can run this to the table can't you?



i have v1 installed and working and wanted to update to v2 without loosing uploaded torrents, users and lot of information.

can someone help me doing that?
thanks a lot