 Is It Possible To Move Only Part Of A Mysql Database, more like copying it and putting it elsewhere |
|
|
|
|
  |
 May 4 2006, 05:27 AM
Post
#1
|
|
|
Hidden Secrets can't be told threw just words. One must feel what the other feels to truely understand...  Group: Members Posts: 1,523 Joined: 8-January 06 From: Sacramento California Member No.: 16,756  |
Ok, well on my forums, i have two different forums, one for Role Playing (Harry Potter Role Playing not $3x) and the other is for general harry potter discussions, and i added over 100 smilies to my rpg forums, and i am guessing that the area that they store the shortcuts for it is in a mysql database because i cannot find it anywhere else, and so i am curious if there is any way that i can copy the part of the mysql database and move move to copie to the other database, so i dont have to enter over 100 shortcuts AGAIN....because i basicly added all of the yahoo messenger smilies
|
 |
 
|
|
May 4 2006, 07:45 AM
Post
#2
|
|
|
$p4m 0n j00 $h4m3 m3 0nc3 $p4m 0n m3 $h4m3 m3 7\/\/1c3 Group: [HOSTED] Posts: 6,304 Joined: 21-September 04 From: 9r33|\| 399$ 4|\|D 5P4/\/\ Member No.: 1,218  |
go to your phpadmin click on your ipf db look for a file call ipb_emoticons or something close to that.
But I give you a little warning though something could go wrong when you copy it and try to override it thoguh, you might get a mysql error. But also regaurdless if you copy the db you still have to add them manually though. |
|
|
|
|
May 11 2006, 09:57 PM
Post
#3
|
|
|
Premium Member Group: Members Posts: 193 Joined: 20-December 05 Member No.: 15,962 |
Make sure you download a backup of your MySQL database before you even open phpMyAdmin. Two bad clicks can ruin your forum.
Have you ever worked with phpMyAdmin? |
|
|
|
|
May 12 2006, 04:18 AM
Post
#4
|
|
|
A computer once beat me at chess, but it was no match for me at kick boxing.  Group: [MODERATOR] Posts: 3,874 Joined: 24-July 05 From: In Trouble Again... still? Member No.: 9,787  |
What happened was: a Data Table from one Forum was 'exported' and then "imported into the other forum. No biggie, but a back-up had been performed, yes.
|
|
|
|
|
May 12 2006, 04:23 AM
Post
#5
|
|
|
Hidden Secrets can't be told threw just words. One must feel what the other feels to truely understand... Group: Members Posts: 1,523 Joined: 8-January 06 From: Sacramento California Member No.: 16,756 |
lol no i had never worked with PHP My Admin, lol but jlhaslip helped me out a ton! and walked me through it thanx again jlhaslip!! and since this is solved, this can be closed...hoping a mod see's this post, because since the report button is broken, i dont feel like pming someone
|
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 24th July 2008 - 12:18 PM |