Advertisement:

Author Topic: How to move database of froum  (Read 3100 times)

Offline king999

  • Jr. Member
  • **
  • Posts: 229
  • Gender: Male
    • Welcome to the ShareTheTrick :: Your Source for Full Downloads. - Index
How to move database of froum
« on: February 05, 2012, 09:02:36 AM »
hello i am back after 1 year actully i closed my old froum now i started new froum i have whole backup of my old forum now i want to add members of my old forum in new froum tell me how to do that.
Is anyway without phpadmin because i am using free hosting they not support upload database via phpadmin
if you know any webhosting free hosting so also please suggest me.

Online NanoSector

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 10,045
  • Gender: Male
    • rick2288 on Facebook
    • Yoshi2889 on GitHub
    • Test Server
Re: How to move database of froum
« Reply #1 on: February 05, 2012, 09:10:30 AM »
You need to have phpMyAdmin to manage your databases ;)
We can't help you when you don't have that.

I use P.C.Tweakr and my site runs great :)
My Mods / Mod Builder - A tool to easily create mods / Support team member / Website - Help us test SMF 2.1!
"I've heard from a reliable source that the Answer is 42. But, still no word on what the question is."

Offline king999

  • Jr. Member
  • **
  • Posts: 229
  • Gender: Male
    • Welcome to the ShareTheTrick :: Your Source for Full Downloads. - Index
Re: How to move database of froum
« Reply #2 on: February 05, 2012, 09:19:17 AM »
Ok well you tell me i ******s to new server that have phpadmin

Online NanoSector

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 10,045
  • Gender: Male
    • rick2288 on Facebook
    • Yoshi2889 on GitHub
    • Test Server
Re: How to move database of froum
« Reply #3 on: February 05, 2012, 09:21:21 AM »
Ok well you tell me i ******s to new server that have phpadmin
I'm not entirely sure I understand what you just said ???

But the link I provided is a host with PHPMyAdmin.
My Mods / Mod Builder - A tool to easily create mods / Support team member / Website - Help us test SMF 2.1!
"I've heard from a reliable source that the Answer is 42. But, still no word on what the question is."

Offline king999

  • Jr. Member
  • **
  • Posts: 229
  • Gender: Male
    • Welcome to the ShareTheTrick :: Your Source for Full Downloads. - Index
Re: How to move database of froum
« Reply #4 on: February 05, 2012, 09:26:07 AM »
where i you provided i want free hosting actually.

Online NanoSector

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 10,045
  • Gender: Male
    • rick2288 on Facebook
    • Yoshi2889 on GitHub
    • Test Server
Re: How to move database of froum
« Reply #5 on: February 05, 2012, 09:31:29 AM »
where i you provided i want free hosting actually.
That's free :)

http://www.pctweakr.com/billing/index.php
Take a peek there.
My Mods / Mod Builder - A tool to easily create mods / Support team member / Website - Help us test SMF 2.1!
"I've heard from a reliable source that the Answer is 42. But, still no word on what the question is."

Offline king999

  • Jr. Member
  • **
  • Posts: 229
  • Gender: Male
    • Welcome to the ShareTheTrick :: Your Source for Full Downloads. - Index
Re: How to move database of froum
« Reply #6 on: February 05, 2012, 09:52:03 AM »
It's very low bandwith and space any other.

Online NanoSector

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 10,045
  • Gender: Male
    • rick2288 on Facebook
    • Yoshi2889 on GitHub
    • Test Server
Re: How to move database of froum
« Reply #7 on: February 05, 2012, 10:43:34 AM »
It's very low bandwith and space any other.
If you want higher space and bandwidth you most likely are searching for an overselling host..
My Mods / Mod Builder - A tool to easily create mods / Support team member / Website - Help us test SMF 2.1!
"I've heard from a reliable source that the Answer is 42. But, still no word on what the question is."

Offline king999

  • Jr. Member
  • **
  • Posts: 229
  • Gender: Male
    • Welcome to the ShareTheTrick :: Your Source for Full Downloads. - Index
Re: How to move database of froum
« Reply #8 on: February 05, 2012, 05:05:46 PM »
Now i get host with phpadmin now to tell me how to use my old forum members in new one.

Offline king999

  • Jr. Member
  • **
  • Posts: 229
  • Gender: Male
    • Welcome to the ShareTheTrick :: Your Source for Full Downloads. - Index
Re: How to move database of froum
« Reply #9 on: February 05, 2012, 05:30:18 PM »
WHen i am import db via phpadmin i get this error.
Quote
Error

SQL query:

-- -- Dumping data for table `smf_members` -- INSERT INTO `smf_members` (`id_member`, `member_name`, `date_registered`, `posts`, `id_group`, `lngfile`, `last_login`, `real_name`, `instant_messages`, `unread_messages`, `buddy_list`, `pm_ignore_list`, `message_labels`, `passwd`, `email_address`, `personal_text`, `gender`, `birthdate`, `website_title`, `website_url`, `location`, `icq`, `aim`, `yim`, `msn`, `hide_email`, `show_online`, `time_format`, `signature`, `time_offset`, `avatar`, `pm_email_notify`, `karma_bad`, `karma_good`, `usertitle`, `notify_announcements`, `notify_regularity`, `notify_send_body`, `notify_types`, `member_ip`, `member_ip2`, `secret_question`, `secret_answer`, `id_theme`, `is_activated`, `validation_code`, `id_msg_last_visit`, `additional_groups`, `smiley_set`, `id_post_group`, `total_time_logged_in`, `password_salt`, `mod_prefs`, `warning`, `ignore_boards`, `passwd_flood`, `new_pm`, `pm_prefs`, `openid_uri`, `pm_receive_from`, `referrals_no`, `referrals_hits`[...]

MySQL said: Documentation
#1054 - Unknown column 'referrals_no' in 'field list'

Offline king999

  • Jr. Member
  • **
  • Posts: 229
  • Gender: Male
    • Welcome to the ShareTheTrick :: Your Source for Full Downloads. - Index
Re: How to move database of froum
« Reply #10 on: February 06, 2012, 12:23:04 AM »
Please any one help me.
I have database of smf rc5 now i install latest version of smf on my new domain .

Offline king999

  • Jr. Member
  • **
  • Posts: 229
  • Gender: Male
    • Welcome to the ShareTheTrick :: Your Source for Full Downloads. - Index
Re: How to move database of froum
« Reply #11 on: February 06, 2012, 10:09:51 AM »
well i solved my issue no one help me regarding in this well thanks guys for not helping me.

Online NanoSector

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 10,045
  • Gender: Male
    • rick2288 on Facebook
    • Yoshi2889 on GitHub
    • Test Server
Re: How to move database of froum
« Reply #12 on: February 06, 2012, 01:26:41 PM »
well i solved my issue no one help me regarding in this well thanks guys for not helping me.
We are all volunteers, and we'll reply when we know the answer, have read your problem and have time to reply..
My Mods / Mod Builder - A tool to easily create mods / Support team member / Website - Help us test SMF 2.1!
"I've heard from a reliable source that the Answer is 42. But, still no word on what the question is."