MYSQL :: Corrupt Text After Moving Forum

Moving Forum That Uses Database
AOn my website that I am busy rebuilding, I have a forum that uses the MySQL database. The current path of the forum is this:

ingwaz.nl/main/ingwaz.nl/berichtenbord/mercuryboard/index.php

Which is obviously way too long, blame it to inexperience when it comes to designing websites :rolleyes: I want the path to become this:

ingwaz.nl/main/berichtenbord/index.php

The question is, can I move the forum from one folder to another without problems or is this going to mess up the linking with the tables in the database?

Moving A Forum (phpbb2) With Apache And MySQL
I was wondering if there was a tutorial for moving a complete server from one PC to another and have it exactly like it was, besides IP's exc exc. If you could give me a few steps to back up all my stuff in MySQL and PHPBB it would answer my question.

How Do I Extract All My Text Data Input From A Php Forum?
I manage a small website using phpbb on a Solaris platform, using mysql 4.x. After being repeatedly hacked, I'd like to migrate to a less singled out forum bb, but without losing my data--most of which is in Chinese characters (so doing string searches is definitely out).

I have direct file access via ftp to the server, and i've also downloaded the corrupted files, only two of which have been modified by the hacker, namely,

phpbb_config.ISD
phpbb_forums.ISD

Unfortunately, the last previous backup the hosting company performed was some 8 months before...

Moving Text
I have list of titles in a database, many of which begin with "the..."
Is there an sql statement to move the "the" from the beginning of the column
and place it at the end
eg "The Big Blue House" would become "Big Blue House, The"
"The Cat and Dog" would become "Cat and Dog, The"

Moving Text In A String Within A Row
I have list of titles in a database, many of which begin with "the..."

Is there an sql statement to move the "the" from the beginning of the column
and place it at the end

eg "The Big Blue House" would become "Big Blue House, The"

"The Cat and Dog" would become "Cat and Dog, The"

Corrupt Downloads
I'm trying to download MySQL but no matter which mirror I download the zip file from the file I get doens't work. My computer keeps saying it is "no zip file, bad zip file or part of a split/spanned zip file" What am I doing wrong? And can anyone point me in the direction of a good tutorial on running it locally when I finally get it installed?

Corrupt MySQL DB
I'm in a bit of a conundrum on this one. I have a MySQL 5.0 DB running on CentOS 5 that seems to have corrupted. In PHPMyAdmin, all of the tables show as "in use". When I attempt to repair them, I receive both mysql error #1017 - Can't find file with a path to the directory where it should be, as well as errno 13, which is a permissions error.

In mysqladmin, I can navigate to the DB, show the tables which appear to have data, but if I attempt even a simple SELECT, I receive the same errors.

The mysql docs have information on repairing individual tables, but I haven't seen any references for EVERY table being hosed.

Deleting Corrupt Tables
I'm pretty new to MySQL but have a reasonable grasp of relational databases... I created a new database and attempted to import a table structure into it... Now I obviously had something wrong in the import data because I got an error... Sorry didn't write it down.

Now if I attempt to open the database I get the following error #1142 - SELECT command denied to user 'runey'@'localhost' for table 'test'

What I would like to do is delete the faulty tables so I have an empty database, but if I try that then I get this error #1142 - DROP command denied to user 'runey'@'localhost' for table 'test'.

I have asked my ISP to delete the whole database so I can start again, but would like to know if there was something I could have done, just in case it happens again.

Repair Corrupt Tables
I have a couple of tables in a database the give me the following error when I try to open them:
thanks!
'can't open file: 'clinch_a.ibd (errno:1)'
What can I do to fix this problem.

Corrupt BLOB Data
I'm using mySQL to store data in a blob field. This seems to work on some machines, and not on others. What usually end up happening is that the data ends up getting corrupted either while uploading or downloading it.

I am not sure what's wrong. Using Perl to upload and download the data. I am using the latest DBI package.
binary file size = 4168 bytes

Possible errors:
*these errors depend on what machine the code is run on
4168 bytes retrieved, but contains incorrect data
<4168 bytes retrieved
<4168 bytes retrieved
<4168 bytes uploaded
>4168 bytes uploaded

The Perl code works on my unix machine, but not on my win machine
The Perl code works on my co-workers win machine, but not our unix server.

Repair Corrupt Table
I am using xoops (a CMS) and MySQL on a website with not so much traffic. I am using "phpMyAdmin - 2.8.0.3-Debian-1" with "MySQL - 5.0.21-Debian_3-log" on a Debian unstable.
Three tables have gotten corrupt recently and won't let themselves be repaired. When I use repair it says status OK, but if I try to delete a record or if I analyze the table again, it says that the table was reported as crashed and that it needed a repair. The only useful message I get, if I analyze the table is about wrong key at page 111616.

Innodb Corrupt? > Incorrect Information In .frm
I have a database from shared hosting that is corrupted. It is a mysql database. It feds out that the corrupted tables are of innodb type. The hoster didn't make backups, so I really need to repair this database.
I have given some hints to my hoster. It feds out that the hoster has upgraded the mysql-server to 5.0.27. I conclude from my internet research that the repairing of innnodb tables should be quite feasible. I directed my hoster to http://dev.mysql.com/doc/refman/5.0/...-recovery.html, but according to him this doesn't work.
The error message that I see when accessing the corrupted tables looks like

#1033 - Incorrect information in file: './foo/bar.frm'

Detecting Corrupt Table Structure?
I think I may have a corrupt table.

Problem:

An INSERT leaves 3 fields (City,State,Country) blank 30% of the time. I added 3 additional columns: myCity, MyState, myCountry to the end of the table and modified the INSERT to put the same information into these fields and they work perfectly, whereas the prior fields are still occasionally blank. I am suspecting a corrupt table structure. MySQL Administrator reports all OK, however.

Environment: Windows Server 2003, MySQL 4.1.9, MyODBC 3.51.10 (not 10-2). Table created originally from Access database and conveted to MySQL MyISAM with "Access2MySQL Sync" product from DMSoft.

Your Database May Be Corrupt Or You May Have Copied The InnoDB
I am seeing the below message in the log file. The only reference I can find about it points to a bug. The link provided confuses me more. Do I have a problem or not is my question.

Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: for more information.

Can A Mysql Error Corrupt A Password File?
This may not be the appropriate place to ask this, but I'm not sure where else to go.

I created a mailing app for a customer to send out bulk emails -in batches- using phpmailer. Yesterday an email address was encountered that had an apostrophe in it, and mysql stopped the mailing and spit out an error. I received an email from the person sending the mailing to inform me of this. I went into phpmyadmin and fixed the address.

Well, a couple hours later I got a phone call from the client saying that nobody could access their website. They were receiving 'password denied' connection errors from mysql. The solution was to go into the server's control panel and reset the master password for the site.

Has anybody heard of this before? Could an apostrophe in mysql actually corrupt the password file on a cpanel server?

More importantly, the client is blaming me for this problem. I think it was just a coincidence. But, of course, I'm not sure.

Set Up New Forum
I would like to set up a forum on an FTP server. I have downloaded a Forum template but I do not know how to use MySQL with it. How should I upload it and make it useable for people?

I do not have the luxury of spending very much money, this would be a Guild Thread for people that play an mmorpg with me.

Wp-Forum DB
I get this problem whenever I go to my forums page.
PHP Code:

WordPress database error: [Unknown column 'sort' in 'order clause']

Forum
I am thinking of making a forum from scratch using PHP and MySQL, what would be thwe best way of doing this?

DB For A Forum.
i have worked with DB before but not with mysql and not on this level.i need to create a DB for a forum i have downloaded, but where to start?
i am using apache2triad.
i am aware i have to create a DB for the forum but i have no info on how. i create a DB and it wants to know about tables and so-on.
now what do? how many tables do i need and where will i get this info.

Forum Tree
I am trying to find an elegant solution for a forum tree, but I don't know enough about MySql.

Let me try and explain what I try:

1. Someone writes a story (A)

2. Someone gives a reaction (A1)

3. Someone else gives a reaction (A2)

4. Someone reacts to A1 (A1a)

5. Someone reacts to A1a (A1aI)

etc. etc.

I would like the order on the page to be the logical one, ie:
A
  A1
     A1a
          A1aI
  A2
  A3
     A3a
  A4
etc. etc.

What fields would I have to add to be able to fetch the entire forum in the logical order with only one query? Do I add a 'Parent' field plus an index? Or other fields? What would the query look like?

Maybe you think I should work it out by myself, and you would be right there, but I have been breaking my head over this for quite some time already.

Installing A Forum
Well im talking with my friend who is hosing my webserver.

Now when I try to install vbulletin and go and edit the config, the port is wrong. My friend says he dose not know how to figure out with port im on. So far i know its no 3306.

DB Back-up SSH || Forum
when i backed up dB using SSH db is for exmaple 50 MB

Code:

mysqldump -u zodehala -p123 db > backup/vb.sql

but if i use vBulletin its interface to back up db is for example 80 MB
What is the difference between them ?
what is technical explain ?

MySQL For My Forum
Hi folks sorry if i post this in the wrong forum i wasn't sure , Anyway im completely new to this so please bare with me, Im with a webhosting company called oneandone in the UK who host my website but they only offer me a maximum MySQL databse size of 100MB so i was wondering if i can and how i would be able to setup my own databse on my own computer Win XP Pro to host my forum myself but i still want my hosting company to host my website

Phpbb Forum
I'm experiencing some problems trying to get my phpbb forum to work with mysql. I'm running the newest version of apache, and php is installed and working, but I'm not quite sure about what I have to do with the MySQL database part to get it working. If anyone knows of any tutorials or anything I would be grateful
Just for reference: I'm a newb when it comes to both php, and MySQL.

Custom Forum
I'm creating my own forum... unfortunately, my sticky script is being quite unpleasant. The sticky is.. sticking to the bottom!Here's my SQL query:Code:

$fQuery = mysql_query("SELECT * FROM `forumtopics` WHERE `forum` = '$f' ORDER BY `sticky` ASC, `timeEdited` DESC LIMIT $limit1, $limit2")
or die(mysql_error());

What's wrong? `sticky` is a boolean column, and `timeEdited is just a number (generated with time()).

I Have Way Too Many Inserts/updates In My Forum
when someone posts a thread theres 2 count queries
2 fetch queries
3 insert queries
and 2 update queries

so my question is, is there a way to do a sort of join query for inserts and updates?

also, has anyone got some mysql musts?
i dont see a mysql tips thread
i think there should be one

Coding A Forum To Read On A CD
I have a fairly large ubb that I would like made available on CD. Is it possible to do this?

One Database For Site And Forum?
I have a site and a forum and I want to use one database for them, so when somebody registers in the site - to be registered automatically in the forum.
Is this possible and if it is - how?

Merge Two Forum Databases?
I have two phpbb2 forums which I would like to integrate into one forum. I've installed a new forum in the location where I would like the merged forums to go. All I need now is a way to get both of the old databases into the new one I made. I've backed up both databases, but everytime I try to import them into the current one I get errors.

I know I barely know what I am doing, so how can I do this correctly? The tables are the same for both databases, so I just need the data in the tables.

Forum Refresh Issues
I pass a few variables through the URL in GET statements, and I have the problem when people press back it gives the screen asking to resend the information. I also get the problem when I post a response and press back and it posts the response again. Is there a simple way to stop this besides writing a script limiting the posts per certain amount of time??

Forum Search Not Working
Trying to find information about character sets, probably a fairly basic question ... but frustrated because the Search option in the forums doesn't work for me either on my Linux/Ubuntu box or on a W2000 PC.

I have cookies enabled for forums.mysql.com on both, but all I get is a blank screen.

Forum Code Using MySQL/PHP
I am currently working on coding a forum for my website. I am fairly new to this coding stuff so i apologise if if this is something really easy.
The way i have coded the forum so far is that one page will display a list of all the topics within that forum. It also displays the unique ID of that topic. The topic headings are set up as a link which when clicked i want it to search the database for all the replies that link to that topic. I have linked the replies to the topics using simply the topic ID.
The problem i am having is i cant work out how to pass the ID variable along in my link, or how to code the link so it will find the replies for that particular topic.
Maybe i have gone about it all totally wrong and need to start from scratch.

Forum (IPS Driver Error)
Whenever i go to send a PM in my invision forum the following error comes up,

Quote: mySQL query error: SELECT m.mgroup_others, m.id, m.name, m.members_disable_pm, m.members_display_name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM forummembers m, forumgroups g
LEFT JOIN forummember_extra me ON (m.id=me.id)
WHERE LOWER(m.members_display_name) IN ('jabski')
AND m.mgroup=g.g_id

SQL error: Unknown column 'm.id' in 'on clause'
SQL error code:
Date: Thursday 19th 2006f January 2006 08:53:58 PM

any idea what this is, i have reinstalled the forum twice and refreshed the database twice

Duplicate Forum Messages
What is the most efficient way to check if a forum user is posting a message they already posted? Would getting a select count of the number of duped messages be more efficient, or is there a better way?Example: bob posts 'kfafasfas', then tries to post 'kfafasfas' again as a new message, but it's a dupe of the first post.

Forum Related Table Structure
I didn't know whether to post this in the php forum or mysql--we'll try this one:

Suppose that I have a mysql-php based forum running. Users table (simplified) looks like:

Users
------------
user_id (int, primary_key)
username (varchar(30))
password (varchar(30))
read_post_ids (text)

Currently, 'read_post_ids' is a comma-separated list of all the post ids that a user has clicked on, which are marked as such.
Currently a php script is resposible for reading the list into an array, looping through to find values if needed, and on a write back to the db it takes the array and turns it back into a CSV string.

Problem: The table isn't even in 1NF because of this field, and extra processing is going on. As an alternative, I have considered dropping 'read_post_ids' from this table, and starting a new table:

Read_Post_Ids
-------------
id
read_post_id
user_id

This normals the tables and makes queries easier, but I worry about storage. Let's say I have 10,000 forum users, that on average read 20 posts per day. that is 200,000 table rows per day. In a year, I have 71,000,000 rows. If I index the fields (as I probably should for speed), the rows take up even more room. If I decide to only allow a user a maximum of 300 stored 'read posts' (for example), then I probably have to add a timestamp field so I can delete the older ids, which takes up even more space.

So is there a preferred method here? I would prefer that the tables be normaled, but I worry about the table growing out of hand in terms of size, and at some point becoming slow.

Sample Schema For A Discussion Forum
I'm trying to design tables for a discussion forum on my website. I'm looking for a sample schema to start with.

Forum Database Merging Question
I am very new to databases although I have backed up, and imported several forum db's using BigDump. That's as far as my knowledge goes i'm afraid.

I have two similar smf forum dumps which I would like to merge into one database. If you imagine and old forum added to a new forum, or two different forums that decide to merge all their boards, posts and members into one.

I have spent some time now reading up on sql, searching for scripts and creating databases in an attempt to get this to work. As I have said, I am a real novice at this kind of thing and would really appreciate some help.

Basically a script would be a dream come true, but I have yet to find one. I am prepaired to read, learn and experiment if somebody could just point me in the right direction. Lastly, if this has been achieved before, a link to a guide or howto would be amazing.

Auto Close Forum Posts
Need help writing a query that checks the date a particular forum post was posted, compares it with the current date. If there is a difference of 30 days, the forum post should be closed.

The database table is called "Discussions"
The "DateCreated" Field of a particular post is Datetime type in the form 2007-04-12 09:21:46

Compare this date of every post with current date, if more than 30 days have passed, then add a 1 to the "Closed" field.

Can I Recover My Forum Database From Ibdata1
Deleted my account in cpanel and lost all the database.. I looked around on my server and found a file called ibdata1 172mb's

This was about the size of my db so im guessing it has somthing to do with it!

Anyone know much about these files and if i might be able to, restore my forum some way with it?

Combining A Chat & Forum Database
But how would I combine a chat and forum so that if one registered for one of them then they would register for both? Basically how would I make a database allowing someone access to any part of the site?

Php Mysql Comments/forum Layout
i ve made a script where php INSERT's data into a table. a table which has "poster" "comment". could anyone please tell me how to echo these results starting from the newest to the last result? use the same kind of layout as a forum if that helps.. o and has timestamps got any use in this?

Forum Outta Mysql Space
my forum (vbulletin) is currently not connected a database because my hosting says ive used 150 megs outta the 100 allowed and theres no way to increase the space.

i was wondering if it is normal to for forums to use that much space? i have about 7,500 users 80k posts. i dont know what to do, is it normal for a forum to use that much mysql space and would anyone know of a good realiable host for mysql hosting because i might have to change servers.

How Do I Change The Date Of A Post On My Forum Site?
Hi, I have started a forum site with a couple of friends. The forum runs on xoops using php 4 with a mysql (4) database. I accidently deleted a few posts. No problem there because I had a copy of the text and posted it again. But the problem is the date and time - obviously it shows the date of the new post and not the date of the deleted one. As I am a newbie still experimenting with mysql and php, I'd sure appreciate your help.

Summary:
=======
I need to change the date of a post in the mysql database. I access the database using phpmyadmin.

Two Sites Using The Same Forum Database User List
I know it's possible for TWO different sites to use the same database. Let me explain.

I have siteA and it runs a forum. Through the site, users of the forum can login using their forum ID. I now create siteB on a different domain, but on the same hosting service. I want users from siteA to be able to login with their name from that site on siteB. How would I do this? I'm using myBB as my forum software.

Exporting Blob / Text Column With Hyphen Delimited Text
I have a table that contains a column (blob, text type, formatted as MEDIUMTEXT) with text hyphen (-) delimited, listing

rooms by numbers, and I need to export or insert that data into another table, where all other info on the other columns

remains the same, but I need the data on the blob field to be single listed

another words, i have a table like this (example):

School Rooms
Your Hometown High School 1034-1035-1037-1039
My Hometown High School 208-178-1432-1728

I need it like this:

School Rooms
Your Hometown High School 1034
Your Hometown High School 1035
Your Hometown High School 1037
Your Hometown High School 1039
My Hometown High School 208
My Hometown High School 178
My Hometown High School 1432
My Hometown High School 1728

Automatically Generate Text Excerpt For Text Near Keyword Hits?
I would like to generate an automatic text excerpt showing the text close to the first occurance of a keyword needle in a text haystack.

For example: searching for

keyword = "foo"

in a table called Webpages in the column Content = "Yadda, yadda, yadda. Bla, bla, bla foo yadda yadda yaddda bla bla bla"

would return a column called Excerpt = "...a, bla foo yadda yadd..."

Is this best done with PHP after fetching the entire column Content, or will it be more efficient to do directly with MySQL?

What would that SQL query look like?

Need To Insert Data From A Text File Into A Medium Text Field.
How can I go about inserting data into a MEDIUMTEXT field from an existing text file using Java.