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?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Corrupt Text After Moving Forum
hello i just moved my vbulletin forum to another server, but the forum is in spanish and after moving all the database the special spanish characters are corrupted in all the forum, for example instead of Quote: Tamaño máximo para subir archivos Quote: Tamaño máximo para subir archivos the new server is 4.1.20 and the old one is 4.1.14, theres any way i could solve this?
View Replies !
View Related
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.
View Replies !
View Related
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.
View Replies !
View Related
Moving Database
I have about a 2 GB Innodb database in MySQL 4.0.12 that I need to move over to a maching that has 5.0.37 installed. Both are WinXP Pro SP2, and on the same subnet LAN. When I use the MySQLAdmin GUI tool and back up the database on the first machine, it backs up the database and the mysql database fine. When I go to the second machine and run MySQLAdmin GUI tool, it connects to the second machine fine, but when I try to run Restore, and it starts to analyse the backup file, it goes for about 204000 bytes and then says Please tell me, step-by-step the easiest and best way to move the 4.1.12 database, along with its users and permissions from that machine to the machine running 5.0.37
View Replies !
View Related
Moving Sql Database
I'm trying to move my database to another server. I've so far downloaded the database to a wordpad file on my desktop from the old server. When I try to import it to the new server sql I get the error that's it's to large (Max: 2,048KiB) the file I'm moving is about 2100 ...little to much I guess. I then tried gziping it and importing it, but then get the error: (You atmysqlted to load file with unsupported compression (application/gzip). Either support for it is not implemented or disabled by your configuration.)
View Replies !
View Related
Moving A MySQL Database
I know that you can export the sql to a file, which I have done already. But to make it work on the new server what do I do? Do I just upload it and run the file? Or do I need to SSH it? Or can I write a PHP script to create the database and subsequently insert all the data?
View Replies !
View Related
Moving Data From One Database To Another
MySQL - 4.1.20 phpMyAdmin - 2.8.2.4 UNIX server: localroot via UNIX socket control panel: Plesk All of this occurs on same server and same domain I have 2 databases on the SAME server. I need to take the data from just one table in (let's call it) dbSource, and add that data into a table on dbDestination. The two tables have all of the same fields, same field names, same data types (because one db started out as a copy of the other db). Let's say that the dbDestination has only 5 rows, but the dbSource has 200 rows. So in the end I'd want dbDestination to grow from 5 to 205 rows. I made sure that the ID field (first field, an auto-increment) has no common values between the 2 tables. I am logged in as (let's say) "user1" now on dbDestination, but when I go into the dbSource I am "user2". I don't log in again or anything, I just use Plesk to navigate to either database, and I originally logged into Plesk as "admin". Both tables have the same name, only the db is different, let's call the tables "Staff". The table has about 30 fields. From what I saw on the internet sources, it may be something like: INSERT INTO Staff SELECT * FROM dbSource..Staff ; also tried ...SELECT * FROM dbSource.dbo.Staff (one time I got the error message "#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 '.staff' at line 2) another time I got " #1142 - SELECT command denied to user 'user1'@'localhost' for table 'staff' "
View Replies !
View Related
Moving Database Queries
I have development server at home which i use to develop my PHP - MySQL code. Recently I finished the database and some pages and I wanted to move it to dedicated server at my provider. I exported whole database using MySQL-Front and imported in on the server without problems using mysql -u root -p < database.sql. Everything seems to be OK but queries that take 2seconds on my machine takes forever on my dedicated server.Does anyone have an idea what could be the problem? I'm using 5.0.24a-log at home and 5.0.27-log at dedicated server.
View Replies !
View Related
Moving A My SQL Database To A Different Host
I have a number of databases and 3 hosts I am currenlty using. One of the hosts has too much down time and I would like to migrate the database before I address issues with him. I want to get the full structure and content across to my new host which had a much better time on line. I am using cpanel for access on the new one and Myadmin on the other both have my SQL and php running the interfaces look virtually identical from this persepctive. If I download from one and upload to the other should I just do a simple download upload operation or do I need to install the database in some way first. The help I've seen talks about command line access but the interface on each is a bit more WYSIWIG than command line so using the tutorial is proving to be interesting.
View Replies !
View Related
Moving Database To A New Sever
I am trying to move my database to a new dedicated server. But when I try to upload it to my server I get this [root@ root]# mysql -uroot -p quad4 </home/josh/mysql/01.08.2006.sql Enter password: ERROR at line 6304: how can I edit the file to see what the error is? When I try to open the file it maxes out my system resources. What would you suggest to edit this?
View Replies !
View Related
Moving Database From One Computer To Another
I glad to be part of this community. The problems I am having is that I need to move the information from a database that I have created on my portable computer to a desktop computer. I zipped the files and then unzipped them in my other pc but the infomarmation was not recognized. I then tried a back up restore and still the same. Is there a way that you can transfer the information without having to recreate the database.
View Replies !
View Related
Moving Database To New Machine
I'm trying to relocate my site to a new host and I'm having a lot of trouble moving the database. I did the export for the old host/database with phpmyadmin. It saved to a txt/sql file with no problems. When I try to import it into the new host/database I get all kinds of syntax errors. Then I realized, after purchasing the new host that: Old host/db = MySQL version 5.0.24a New host/db = 4.0.27 Is there any way to convert a 5.0 db to 4.0?
View Replies !
View Related
Moving Database To New Server
One of my clients is moving to a new server. The site has a MySQL database, so I need to export it from the current server and then import it to the new server, correct? The current server has PHP Admin for a utility tool, but offers a bunch of settings I have no clue about. What are the appropriate settings to make the trasition to the new server as quickly and easily as possible? See attached image.
View Replies !
View Related
Restoring / Copying / Moving Database
I am trying to move a datbase from one machine to another. I have tried two different methods and neither are working. First I tried using : >> mysqldump dbName > backup_file.sql >> mysql dbName < backup_file.sql as the manual outlines, but I have a number of foreign keys resulting in errno=150 because the second command above is trying to restore data which is supposed to be linked to data in other tables that don't exist until that table is reached. So then I tried : >> mysqldump --disable-keys dbName > backup_file.sql >> mysql dbName < backup_file.sql But that did not work either. The most obvious choice at this point is to create a script to restore the tables in the proper order, but this seems kind of tedious and a maintenance headache if tables are added / changed in the future. Next, I tried to simply copy the entire folder for the database. This folder contains *.frm files only (we have created all InnoDB tables). I created the database first then copied the files over to the appropriate folder. When I try to look at the table using the MySQL Control Center I get the error "Error 1016 : Can't open file 'filename.InnoDB' (errno : 1)" I even moved the entire mysql installation folder, but received the same error?
View Replies !
View Related
Moving Database To Alternative Machine.
Have installed version 4.1 on 2 machines. I am trying to copy a database that i created on one machine by simple going to the data folder and copying the database folder pasting it to a removable device. I then copied the folder into the data folder on my second machine. However, when i attempt to do a select * on any of the tables on the second machine, I am told that the table is corrupted or does not exist.
View Replies !
View Related
Moving A Database Without Duplicating Records
I have 2 servers with the same mySQL database on each server, but one server holds the older records one holds new records but there are some records which appear on both servers. I need to move the database from the old server to the new server without doubling up on records. I have taken a backup of the old sql database by going mysqldump --port=3309 --add-drop-table CCRDB > c:MySQL_BKPCCRDB_Backup.sql How do I restore/merge this backup onto the new server without doubling up on records? I was think i have to restore the database to the new machine using mysql –-port=3309 CCRDB < c:MySQL_BKPCCRDB_Backup.sql but im pretty sure this will either completely overite the new database or duplicate some of the records.
View Replies !
View Related
Moving Database To The Live Server
I have an asp application that is currently using Access as a backend database. I have installed mysql on my computer and converted the Access database to mysql. I will be changing the connection string to make it work with asp. My question is that I need to move the database to a live server. What do I need to have on the live server and how do I move the database from one server to another.
View Replies !
View Related
Moving Mysql Database From MAC To Windows
I have to move a database from a MAC with MYSQL to Windows. The MAC has MYSQL 4.0.18 loaded. The phpmyadmin is not working on MAC machine so I tried to just copy the database files to the Windows machine mysql 4.0.21 After this mysql crashes when I try to open the databases with phpmyadmin. A popup window appears and called DBUG Test signal Confirming this message causes mysql to fail. In my phpmyadmin it get the message server not responding. I also tried to recreate the empty tables on the Windows machine and just copy the .MYD and .MYI files into the Windows machine, leaving the .frm files. This worked on some tables but on others I have corrupted data in it and some tables are shown as in use. The MAC mysql database does have 2 files that the Windows doesn't. ._.DS_Store and ._DS_Store. Are the MYSQL files for those 2 system not compatible? If not How can I convert the database files? The database is still working on the MAC so I do not think the database is corrupt.
View Replies !
View Related
Md5 Problem After Moving Database To Another Machine
I moved my MySQL database to my own web server (Windows NT4 server, Apache 2.0.55, PHP v4.4.0, and MySQL v4.0.26). I used "mysqldump" and "mysql -u root -p ccs < sqldumpfile" to backup and reload the tables. Some PHP scripts that work fine on my ISP (MySQL v3.23.58) do not work on my local PC (MySQL v4.0.26). The part of the select statement where the problem lies is: and password='".md5($MD5_PREFIX.$_POST["password"])."' I did some testing via the mysql command line interface and it appears that the md5 function is generating a different value. If I set the password to '123' with no encryption and remove the md5 stuff from the PHP script it works (the $MD5_PREFIX has not been changed and I even did some testing in mysql by hardcoding the value) -- so I'm pretty sure the problem lies with the md5 function. Is there a difference in md5 between different versions of MySQL? If not, can someone point me in the direction of a solution?
View Replies !
View Related
Moving An Existing MySQL Database From
I have an existing database already created on 4.0.25-standard. It is too large to import to my new server via phpmyadmin, so I'm using mysqldump. The new server has MySQL 4.1.12 instead of 4.0.25. I am running this command: mysqldump -u root -p starfall < smf1 --create-options --compatible=mysql40 but I get this: Code:
View Replies !
View Related
Trouble Moving My Msql Database....
Ok, now i've really done this so many times and it's never worked. Basically my current host is really really bad, and i fear it's soon going to close down. My site is a clan, and we really need our forums to be up 24/7. So basically i wanted to move host. I found a good host, and so i downloaded a msql backup in cpanel. And tried to transfer it through "backup" uploads in cpanel in the new host, and my computer freezes. What happens is, it keeps on saying "transfering from 1.127 etc. or transfering from {host url}" and does this for ages. And so i have to close it down and restart computer. Now when i go to php admin, i can only see 100 tables, when there should be 127, on TWO occasions it's been the same... And i got IPS errors in my ipb forums when i try to go to link. So then i try doing it from phpmyadmin, and what happens: "this {username} does not have correct permission for this database" or something like this. all i want to do is move my database across without any problems. i kno i might have gone wrong somewhere?
View Replies !
View Related
Moving Partition To Partition MySQl Database
I've tried moving the database from one partition to another and now I'm = getting the following error: # Starting mysqld daemon with databases from /data/mysql 030820 23:48:08 mysqld ended When I issue #/ /usr/share/mysql/mysql.server start Anyone have any idea what's gone wrong. I changed the datadir in both = /etc/my.cnf and /usr/share/mysql/mysql.server. This is on a MySQL-3.23.55-1 server.
View Replies !
View Related
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.
View Replies !
View Related
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.
View Replies !
View Related
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()).
View Replies !
View Related
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 ?
View Replies !
View Related
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.
View Replies !
View Related
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.
View Replies !
View Related
2 Databases For Forum
I have a website with a forum, build in PHP and using a SQL database. When I use the phpmyadmin.com I can see my SQL database localhost/websitename_dk. Now I want to build another forum, using a complete other SQL database. Q: How do I create another SQL database at my server e.g. localhost/anothername so I have 2 databases? If I install the other forum, it will delete all my tables in my database, unless I give it another name.
View Replies !
View Related
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
View Replies !
View Related
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.
View Replies !
View Related
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
View Replies !
View Related
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.
View Replies !
View Related
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.
View Replies !
View Related
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.
View Replies !
View Related
|
TRACKER
