MyBB Community Forums

.
Name of database file, which has the uid#s (and related to usernames), so can find with FileZilla etc ?

Can you elaborate on what you're trying to do? It sounds like you're confused about how data in the database is stored and accessed.

.
Thanks for the reply.
Pretty sure I am confused, not that familiar with the database architecture and php.

Best way I can describe, from what Ive found so far, is Im looking for the file/s from where the backup 'text file',
-Database Backup- Generated: 25th December 2014 at 05:40-, comes from.
Some info I found indicated "the files mysql_db_inserts' and 'mysql_db_tables contain the whole DB structure.", but am guessing they (php files) are creating tables somewhere, but where ?
Hope that helps.

(2014-12-24, 10:01 PM)Nathan Malcolm Wrote: [ -> ]Can you elaborate on what you're trying to do? It sounds like you're confused about how data in the database is stored and accessed.

users table (eg. mybb_users) in the database consists of users details (uid , user name , joined date .. etc)
it is not easy to interpret the structure of database by looking the database file through a text editor.

see search results for basics of MySQL database

MySQL stores data in a specific directory on the server, which (generally) isn't accessible on shared hosts, and isn't in a human readable format.

If you're looking to create a backup file, a file which contains the queries to create the tables and insert the data in to those tables, you need to export the database. You can either do this via phpMyAdmin, the MyBB admin control panel, or any utility which allows you to create backups.

To be clear, you can't access the raw data via FTP. It still isn't clear if you're looking to create a backup or modify the database, or something entirely different.

.
Thanks for the info.
In this situation, the only way I can access the db is ftp (FileZilla) and Notepad++.
Dont really have the access to install something like MySQL.
The 'backup' text file did seem to have uid info for users, and it was not easy to read, but did seem to make some sense.
So at this point I am just trying to figure out where that info is coming from on the server ?
And, thought maybe it may be easier to view 'directly' (ilo viewing backup text file) with Notepad++ ?

(2014-12-25, 06:34 AM).m. Wrote: [ -> ]users table (eg. mybb_users) in the database consists of users details (uid , user name , joined date .. etc)
it is not easy to interpret the structure of database by looking the database file through a text editor.
see search results for basics of MySQL database

here is a sample data structure for mybb_users table [MyBB 1.6.x]

--
-- Table structure for table `mybb_users`
--

CREATE TABLE IF NOT EXISTS `mybb_users` (
`uid` int(10) unsigned NOT NULL,
  `username` varchar(120) NOT NULL DEFAULT '',
  `password` varchar(120) NOT NULL DEFAULT '',
  `salt` varchar(10) NOT NULL DEFAULT '',
  `loginkey` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(220) NOT NULL DEFAULT '',
  `postnum` int(10) NOT NULL DEFAULT '0',
  `avatar` varchar(200) NOT NULL DEFAULT '',
  `avatardimensions` varchar(10) NOT NULL DEFAULT '',
  `avatartype` varchar(10) NOT NULL DEFAULT '0',
  `usergroup` smallint(5) unsigned NOT NULL DEFAULT '0',
  `additionalgroups` varchar(200) NOT NULL DEFAULT '',
  `displaygroup` smallint(5) unsigned NOT NULL DEFAULT '0',
  `usertitle` varchar(250) NOT NULL DEFAULT '',
  `regdate` bigint(30) NOT NULL DEFAULT '0',
  `lastactive` bigint(30) NOT NULL DEFAULT '0',
  `lastvisit` bigint(30) NOT NULL DEFAULT '0',
  `lastpost` bigint(30) NOT NULL DEFAULT '0',
  `website` varchar(200) NOT NULL DEFAULT '',
  `icq` varchar(10) NOT NULL DEFAULT '',
  `aim` varchar(50) NOT NULL DEFAULT '',
  `yahoo` varchar(50) NOT NULL DEFAULT '',
  `msn` varchar(75) NOT NULL DEFAULT '',
  `birthday` varchar(15) NOT NULL DEFAULT '',
  `birthdayprivacy` varchar(4) NOT NULL DEFAULT 'all',
  `signature` text NOT NULL,
  `allownotices` int(1) NOT NULL DEFAULT '0',
  `hideemail` int(1) NOT NULL DEFAULT '0',
  `subscriptionmethod` int(1) NOT NULL DEFAULT '0',
  `invisible` int(1) NOT NULL DEFAULT '0',
  `receivepms` int(1) NOT NULL DEFAULT '0',
  `receivefrombuddy` int(1) NOT NULL DEFAULT '0',
  `pmnotice` int(1) NOT NULL DEFAULT '0',
  `pmnotify` int(1) NOT NULL DEFAULT '0',
  `threadmode` varchar(8) NOT NULL DEFAULT '',
  `showsigs` int(1) NOT NULL DEFAULT '0',
  `showavatars` int(1) NOT NULL DEFAULT '0',
  `showquickreply` int(1) NOT NULL DEFAULT '0',
  `showredirect` int(1) NOT NULL DEFAULT '0',
  `ppp` smallint(6) NOT NULL DEFAULT '0',
  `tpp` smallint(6) NOT NULL DEFAULT '0',
  `daysprune` smallint(6) NOT NULL DEFAULT '0',
  `dateformat` varchar(4) NOT NULL DEFAULT '',
  `timeformat` varchar(4) NOT NULL DEFAULT '',
  `timezone` varchar(4) NOT NULL DEFAULT '+5',
  `dst` int(1) NOT NULL DEFAULT '0',
  `dstcorrection` int(1) NOT NULL DEFAULT '0',
  `buddylist` text NOT NULL,
  `ignorelist` text NOT NULL,
  `style` smallint(5) unsigned NOT NULL DEFAULT '0',
  `away` int(1) NOT NULL DEFAULT '0',
  `awaydate` int(10) unsigned NOT NULL DEFAULT '0',
  `returndate` varchar(15) NOT NULL DEFAULT '',
  `awayreason` varchar(200) NOT NULL DEFAULT '',
  `pmfolders` text NOT NULL,
  `notepad` text NOT NULL,
  `referrer` int(10) unsigned NOT NULL DEFAULT '0',
  `referrals` int(10) unsigned NOT NULL DEFAULT '0',
  `reputation` bigint(30) NOT NULL DEFAULT '0',
  `regip` varchar(50) NOT NULL DEFAULT '',
  `lastip` varchar(50) NOT NULL DEFAULT '',
  `longregip` int(11) NOT NULL DEFAULT '0',
  `longlastip` int(11) NOT NULL DEFAULT '0',
  `language` varchar(50) NOT NULL DEFAULT '',
  `timeonline` bigint(30) NOT NULL DEFAULT '0',
  `showcodebuttons` int(1) NOT NULL DEFAULT '1',
  `totalpms` int(10) NOT NULL DEFAULT '0',
  `unreadpms` int(10) NOT NULL DEFAULT '0',
  `warningpoints` int(3) NOT NULL DEFAULT '0',
  `moderateposts` int(1) NOT NULL DEFAULT '0',
  `moderationtime` bigint(30) NOT NULL DEFAULT '0',
  `suspendposting` int(1) NOT NULL DEFAULT '0',
  `suspensiontime` bigint(30) NOT NULL DEFAULT '0',
  `suspendsignature` int(1) NOT NULL DEFAULT '0',
  `suspendsigtime` bigint(30) NOT NULL DEFAULT '0',
  `coppauser` int(1) NOT NULL DEFAULT '0',
  `classicpostbit` int(1) NOT NULL DEFAULT '0',
  `loginattempts` tinyint(2) NOT NULL DEFAULT '1',
  `usernotes` text NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

a sample data row from mybb_users table

--
-- Dumping data for table `mybb_users`
--

INSERT INTO `mybb_users` (`uid`, `username`, `password`, `salt`, `loginkey`, `email`, `postnum`, `avatar`, `avatardimensions`, `avatartype`, `usergroup`, `additionalgroups`, `displaygroup`, `usertitle`, `regdate`, `lastactive`, `lastvisit`, `lastpost`, `website`, `icq`, `aim`, `yahoo`, `msn`, `birthday`, `birthdayprivacy`, `signature`, `allownotices`, `hideemail`, `subscriptionmethod`, `invisible`, `receivepms`, `receivefrombuddy`, `pmnotice`, `pmnotify`, `threadmode`, `showsigs`, `showavatars`, `showquickreply`, `showredirect`, `ppp`, `tpp`, `daysprune`, `dateformat`, `timeformat`, `timezone`, `dst`, `dstcorrection`, `buddylist`, `ignorelist`, `style`, `away`, `awaydate`, `returndate`, `awayreason`, `pmfolders`, `notepad`, `referrer`, `referrals`, `reputation`, `regip`, `lastip`, `longregip`, `longlastip`, `language`, `timeonline`, `showcodebuttons`, `totalpms`, `unreadpms`, `warningpoints`, `moderateposts`, `moderationtime`, `suspendposting`, `suspensiontime`, `suspendsignature`, `suspendsigtime`, `coppauser`, `classicpostbit`, `loginattempts`, `usernotes`) VALUES
(1, 'admin', '913530a30a5390e5b8635e990922a5d5', 'lloQ4guW', 'ImWdFEiC2FLBWjkm4wl4uu6FtvBAMyUVI6w5pGdTGW87KJhiaT', '[email protected]', 4, '', '', '0', 4, '', 0, '', 1406619952, 1417805704, 1413723776, 1407345087, '', '0', '', '', '', '', 'all', '1', 1, 0, 0, 0, 1, 0, 1, 1, 'linear', 1, 1, 1, 1, 0, 0, 0, '0', '0', '0', 0, 0, '', '', 2, 0, 0, '0', '', '1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can', '', 0, 0, 0, '127.0.0.1', '::1', 2130706433, 0, '', 9254, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '');

if you have plain text of database file (with sql extension) then it consists of lot of data rows like above

Thanks for the info.
Yes, am looking at a backup.sql file on my PC with notepad++, and see similar info.
What file/where, on the server, does that info normally come from ?

Quote:

--

INSERT INTO `mybb_users` (`uid`, `username`, `password`, `salt`, `loginkey`, `email`, `postnum`, `avatar`, `avatardimensions`, `avatartype`, `usergroup`, `additionalgroups`, `displaygroup`, `usertitle`, `regdate`, `lastactive`, `lastvisit`, `lastpost`, `website`, `icq`, `aim`, `yahoo`, `msn`, `birthday`, `birthdayprivacy`, `signature`, `allownotices`, `hideemail`, `subscriptionmethod`, `invisible`, `receivepms`, `receivefrombuddy`, `pmnotice`, `pmnotify`, `threadmode`, `showsigs`, `showavatars`, `showquickreply`, `showredirect`, `ppp`, `tpp`, `daysprune`, `dateformat`, `timeformat`, `timezone`, `dst`, `dstcorrection`, `buddylist`, `ignorelist`, `style`, `away`, `awaydate`, `returndate`, `awayreason`, `pmfolders`, `notepad`, `referrer`, `referrals`, `reputation`, `regip`, `lastip`, `longregip`, `longlastip`, `language`, `timeonline`, `showcodebuttons`, `totalpms`, `unreadpms`, `warningpoints`, `moderateposts`, `moderationtime`, `suspendposting`, `suspensiontime`, `suspendsignature`, `suspendsigtime`, `coppauser`, `classicpostbit`, `loginattempts`, `usernotes`) VALUES
(1, 'admin', '913530a30a5390e5b8635e990922a5d5', 'lloQ4guW', 'ImWdFEiC2FLBWjkm4wl4uu6FtvBAMyUVI6w5pGdTGW87KJhiaT', '[email protected]', 4, '', '', '0', 4, '', 0, '', 1406619952, 1417805704, 1413723776, 1407345087, '', '0', '', '', '', '', 'all', '1', 1, 0, 0, 0, 1, 0, 1, 1, 'linear', 1, 1, 1, 1, 0, 0, 0, '0', '0', '0', 0, 0, '', '', 2, 0, 0, '0', '', '1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can', '', 0, 0, 0, '127.0.0.1', '::1', 2130706433, 0, '', 9254, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '');

if you have plain text of database file (with sql extension) then it consists of lot of data rows like above

It's not the actual database, it's a backup file which creates the database. The data is stored in the MySQL data directory. The only way a backup file can exist if if the data is exported from MySQL and stored somewhere on the server.

Yes, thank you, think/hope   I understand about the backup file, ie 'name.sql', but where, on the server, should the 'mysql data directory' be and/or what should be the name/s of the files in that directory which contain the data ?

(2014-12-26, 03:09 AM)Nathan Malcolm Wrote: [ -> ]It's not the actual database, it's a backup file which creates the database. The data is stored in the MySQL data directory. The only way a backup file can exist if if the data is exported from MySQL and stored somewhere on the server.