I want Copy my Members to new forum

[Mr.Othman]

Hi .. How are you ?

i have forum, and i want copy all Users to new one because i want closed the first forum and open new website with my members without threads


and i want try it in apache server

but i have problem :(

if i am take the Mysql for "user" Table and go to new forum in phpmyadmin

and Sql the User Table

I receive this error message!




SQL-query:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 12, 2006 at 10:43 AM
-- Server version: 4.1.14
-- PHP Version: 4.3.10
--
-- Database: `megamex_vb`
--
-- --------------------------------------------------------
--
-- Table structure for table `user`
--
CREATE TABLE `user` ( `userid` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`usergroupid` smallint( 5 ) unsigned NOT NULL default '0',
`membergroupids` varchar( 250 ) NOT NULL default '',
`displaygroupid` smallint( 5 ) unsigned NOT NULL default '0',
`username` varchar( 100 ) NOT NULL default '',
`password` varchar( 32 ) NOT NULL default '',
`passworddate` date NOT NULL default '0000-00-00',
`email` varchar( 100 ) NOT NULL default '',
`styleid` smallint( 5 ) unsigned NOT NULL default '0',
`parentemail` varchar( 50 ) NOT NULL default '',
`homepage` varchar( 100 ) NOT NULL default '',
`icq` varchar( 20 ) NOT NULL default '',
`aim` varchar( 20 ) NOT NULL default '',
`yahoo` varchar( 32 ) NOT NULL default '',
`showvbcode` smallint( 5 ) unsigned NOT NULL default '0',
`usertitle` varchar( 250 ) NOT NULL default '',
`customtitle` smallint( 6 ) NOT NULL default '0',
`joindate` int( 10 ) unsigned NOT NULL default '0',
`daysprune` smallint( 6 ) NOT NULL default '0',
`lastvisit` int( 10 ) unsigned NOT NULL default '0',
`lastactivity` int( 10 ) unsigned NOT NULL default '0',
`lastpost` int( 10 ) unsigned NOT NULL default '0',
`posts` int( 10 ) unsigned NOT NULL default '0',
`reputation` int( 11 ) NOT NULL default '10',
`reputationlevelid` int( 10 ) unsigned NOT NULL default '1',
`timezoneoffset` varchar( 4 ) NOT NULL default '',
`pmpopup` smallint( 6 ) NOT NULL default '0',
`avatarid` smallint( 6 ) NOT NULL default '0',
`avatarrevision` int( 10 ) unsigned NOT NULL default '0',
`options` int( 10 ) unsigned NOT NULL default '15',
`birthday` varchar( 10 ) NOT NULL default '',
`birthday_search` date NOT NULL default '0000-00-00',
`maxposts` smallint( 6 ) NOT NULL default '-1',
`startofweek` smallint( 6 ) NOT NULL default '1',
`ipaddress` varchar( 15 ) NOT NULL default '',
`referrerid` int( 10 ) unsigned NOT NULL default '0',
`languageid` smallint( 5 ) unsigned NOT NULL default '0',
`msn` varchar( 100 ) NOT NULL default '',
`emailstamp` int( 10 ) unsigned NOT NULL default '0',
`threadedmode` smallint( 5 ) unsigned NOT NULL default '0',
`autosubscribe` smallint( 6 ) NOT NULL default '-1',
`pmtotal` smallint( 5 ) unsigned NOT NULL default '0',
`pmunread` smallint( 5 ) unsigned NOT NULL default '0',
`salt` char( 3 ) NOT NULL default '',
`arcadesettings` int( 13 ) unsigned NOT NULL default '15',
`award` tinytext NOT NULL ,
`profilepicrevision` int( 10 ) unsigned NOT NULL default '0',
`showbirthday` smallint( 5 ) unsigned NOT NULL default '2',
`skype` varchar( 32 ) NOT NULL default '',
PRIMARY KEY ( `userid` ) ,
KEY `usergroupid` ( `usergroupid` ) ,
KEY `username` ( `username` ) ,
KEY `birthday_search` ( `birthday_search` ) ,
KEY `birthday` ( `birthday` , `showbirthday` )

) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =6663





MySQL said: http://localhost/phpMyAdmin/themes/original/img/b_help.png (http://dev.mysql.com/doc/mysql/en/Error-returns.html)

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=6663' at line 74




So please Help me for don't lose 6630 Member

:( :( :(

Thank you

[Lats]

You can use the impex scripts to import only certain tables.

[Mr.Othman]

OK, but how ?

can you help me

and from where i can use impex scripts it

thank you

Good bye

[Steve Machol]

Please read the online Impex import instructions here:

http://www.vbulletin.com/docs/html/impex?manualversion=30501500

[Trevster]

You not be better to just upload the entire database then use the 'Prune Threads' option in AdminCP to bin the threads? Saves faffing about getting the right tables etc...

[Mr.Othman]

Please read the online Impex import instructions here:

http://www.vbulletin.com/docs/html/i...rsion=30501500

but the database Backup in my computer .. not in the server

because i closed the old site .. and take the users backup

and now i want restore it

[Steve Machol]

You need to restore the db backup onto your server.

Note: The only reliable method of restoring a database is with shell access via telnet or ssh. Please see the instructions here:

http://www.vbulletin.com/docs/html/maintenance_ssh_restore

[Mr.Othman]

thank you .. but after restore the users

the username for all user change .. (( just for arabic names ))

why ?

[Steve Machol]

The usernames change? Honestly I've never heard of this before. Can you provide an example of a username before and after the import?

Also which versions of MySQL are you running on tthe old and new servers? And what's the exact backup command you used?