Albus Dumbledore
May 4 2006, 05:27 AM
| | 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  |
Reply
Saint_Michael
May 4 2006, 07:45 AM
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.
Reply
uiop
May 11 2006, 09:57 PM
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?
Reply
jlhaslip
May 12 2006, 04:18 AM
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.
Reply
Albus Dumbledore
May 12 2006, 04:23 AM
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
Reply
Similar Topics
Keywords : mysql database copying putting- Is The Database System Gone Again?
- Errors on PHPMyAdmin again (9)
- How Do I Find My Mysql Password? [resolved]
- Cannot access my MySQL (5)
After all the recent problems, my account has been restored. I have setup my parked domain agin, and
that works fine. However, I can no longer access my MySQL databases (I can from PHPMyAdmin, but
that's all). I had to create a new user for my databases, and created the user with exactly the
same username and password I had before, but some of my web pages do not let me access the pages I
have associated with my databases. Where could i find out what my DB password is? (Although I am as
good as sure I am using the right one). I have tried my old password, the new c...
Remote Access Mysql
- (8)
Is it possible to directly access my local database from my website? For example, if somebody
submits info on my website, the info they submitted would be transferred to my local database
directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
my database to my subdomain is because it would be difficult to keep the website database and my
local database in sync . . . or is there a way to do that? Thanks for any replies....
Is It Possible To Access The Mysql Remotely?
- (10)
I like to experiment with a lot of things and I was thinking of making a sort of instant messenger
in Python, but I want to let people have actual accounts so I need to be able to access the mySQL
remotely. If that's not possible, are we allowed to run Python scripts on the server?...
Phpmyadmin
- Create new database: No Privileges (6)
i can not make a sql for diff srcipt, but the sricpt i have is php, DJ-cpanel.. all tho i can not
install it the error is like this Creating Database Tables No database selected there a mysql
database is made, but i can not use it for othere stuff... plz note that this is Free script and not
for paid.. is there a way that the myqsul can not use sql other scripts? or it maybe not working...
but i am not sure if the script not working or it can be the server may be down on mysql...? ...
I Need Help Transferring Sql Database?
- (3)
ok so i am trying to transfer mediawiki's but i am having trouble with exporting importing the
database. I am using phpmyadmin on both sides of the hosts. When i do the import i get this.
QUOTE SQL query: -- -- Database: `apolopedia` -- CREATE DATABASE `apolopedia`
DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; MySQL said: Documentation #1044 - Access
denied for user 'jaenagle'@'localhost' to database 'apolopedia' I tried to
give my user all rights, but it gave me this also. QUOTE SQL query: GRANT A...
Installing Apache, Mysql, Phpmyadmin Locally
- Solving the "php_mbstring.dll missing" (5)
Since Trap17's CP provide the individual site's owner with goodies like MySql and
PhpMyAdmin, chances are some will want to make use of them. Well, it's fine enough to get that
on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be
expected that most people considering to make use of a database on their site will want to do most
of the tedious job of developing and testing on their own local system before sending the wrapped-up
result on their domain/subdomain. This involves four basic steps (sorry for the compuwi...
Question About The Upgrade And The Mysql Usage ?
- question about the upgrade and the mysql usage? (3)
thanks for the upgrade but i do have question about it QUOTE Domain name zam.trap17.com
Hosting package Beta Subdomains 3 / 99 Parked Domains 0 / 9 Addon Domains 3 / 9 Mysql databases
1 / 99 PostgreSQL Databases 0 / 99 Disk usage 14.25 / 500.00 MB MySQL Disk usage 0.82 MB
Disk space available 485.75 MB Bandwidth (this month) 6.59 / 10240 MB Email accounts: 1 / 99
Email forwarders: 1 / unlimited Autoresponders: 0 / unlimited Email filters 0 / unlimited
Mailing lists: 0 / 99 FTP accounts 3 / 99 1-Bandwidth (this month) 6.59 / 10240 MB ...
Changes In Phpmyadmin
- Access to my database from program not working anymore. (0)
I was wondering if something has changed in the MySQL or PHPMyAdmin section of Trap 17. (Hope I am
explaining this correctly). I run a newsletter system on my website and the details of the people
who subscribed are in a MySQL database. To get those data from the database and to send the
newsletter to all subscribers I use a program called "Qios Pelican". Up to now it always worked
perfectly, but now it cannot seem to retrieve data anymore, yet I have not changed anything to my
setup. I use the MySQL OLEDB Provider driver to connect, and in case it helps, here are the ...
How To Crate Mysql Database?
- urgent help (7)
Hi everyone!
I'm trying to make in my site a page system that allows me to create users
account (with a foto for every user)...
I'm doing that in PHP, I learned all I have to
know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
is messing: ...
Need Help With My Database
- I cannot transfer my old site's database (19)
I Couldn't import my database info via Import from php my admin and i got the .sql file from the
php my admin of my old hosting and every time i try to import it give me an error that i don't
have the permissions to do.... /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
alt="sad.gif" /> What shall i do?? I need Help Please...
Question About Adding Message Board To Site
- Using mysql? (5)
Hi, Super simple question from a simple laddie! Is a MySql database a messageboard? If not
how can I set up a messageboard. Thanks. std split from another topic ...
Installing Phpbb
- database problem (0)
Hey guy's, ive done as you said and tried to install my phpbb without fantastico. I have got to
the the install page then i get a mysql error QUOTE Warning: mysql_error(): supplied argument
is not a valid MySQL-Link resource in /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 331 phpBB : Critical Error Could not
connect to the database Im not sure why this has happened as i have never really used mysql for
...
Phpbb2.17 Mysql Problems
- Just this week they started (4)
The forum has been up and running for about a year and a half. It has been through numerous server
upgrades, etc, including the recent HDD change, but for some reason, just this week it started
throwing this error: QUOTE Could not obtain post/user information. DEBUG MODE
SQL Error : 145 Table './jlhaslip_phpbb2/phpbb_posts_text' is marked as crashed and should
be repaired SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email,
u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail,...
Database Connection Problem
- phpBB2 installation error (5)
*edit* Ok well the original problem has been solved. I have installed phpBB2 on my new how here.
Transfered all of the database files over. On my new forums all of the old posts and everything
shows up right. The problem is when I click the "Go to administration panel" at the bottom it links
me to log into my ACP on my old forums. It changes the url and all. If I hover over the link it
says that it will be directed to the right way, the way I want, but it doesn't. Does anyone
know anyway to fix this?...
Database Errors!
- Started after HDD change.. (5)
Hello, I am having database errors. They started after yesterdays HDD change. Its all fine when i
refresh site, they not that often but still i get them. It says "could not connect to database". And
i also received mail from gamma.xisto.com which says: QUOTE There has been a problem with the
database! This is a notice email to let you know that SMF could not connect to the database,
contact your host if this continues. so i am contacting my host.....
99 Mysql Databases?
- (2)
I just got my account, and I was wondering: do we really get 99 MySql databases? I've read a
lot of the stuff about it, and it sounded like we only get one database, but my cPanel says that I
have "0 / 99" databases. If it's lying, it's not really a problem, because I could always
just prefix my tables, but I was just wondering why it would say that. If for some reason it was
letting me get more than one database, and I wasn't supposed to, I don't want to get my
account deleted. Does anyone know why it says that? /huh.gif" style="vertical-align:m...
Mysql Access Error[resolved]
- (5)
The MySQL server is Down, please look into this soon. I'm with Trap17 for nearly an year but
never faced any issues witht the free hosting so far, but his is the first time I'm facing this.
Please kindly look into this....
Mysql Server Problems [resolved]
- (3)
hello, well since i installed php-nuke on my site's dir i have seen quite a lot of mysql SERVER
ERRORS, like that the server is going down so now and often is it due to my cms or is the server
having some probs ? this is what i just saw from the statistics: QUOTE Service Status
named up spamd up imap up cpsrvd up pop up eximstats failed syslogd up clamd failed mysql
(5.0.27-standard) failed httpd (1.3.37 (Unix)) up exim () failed exim-26 up ftpd failed Server
Load 16.50 (1 cpu) quote tags added. please use quote tags as needed. review trap17...
Cpanel And Mysql Problem. [resolved]
- (3)
hi all - i'm going to make this brief. my CMS (drupal 5.0) and forum (SMF 1.1.1) cannot connect
to the mysql db. however their files CAN still be accessed. I also tried uploading a file through an
ftp client and the file could be accessed. HOWEVER: cpanel cannot be accessed either. it simply
loads with a blank page. however both worked earlier today. so is there a problem with the server?
and if there is, will it be fixed?...
Mysql Database Setup : Setting Up Mysql Database
- Guide to use MySQL database in your site (4)
A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
server. You can access it using the link in Cpanel. Cpanel can be accessed by
"www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
: IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE...
Sites Disapeard, Mysql Errors? Also Server Folders Deleted
- (18)
Hello its 15:40 and I login see if everything runs oke, and I see numerus things deleted my mysql is
working again. Whats going on? My Webpage couple websites got deleted, and server folder files now
whats going on? /sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> my
forum also give errors but mysql db stil there /sad.gif" style="vertical-align:middle" emoid=":("
border="0" alt="sad.gif" />......
The Difference Between Mysql And Postgresql ?
- (4)
I found those two in cPanel and they loofed nearly the same as each other but what is the difference
? I tried to go to phpMyAdmin and phpPgAdmin and they are nearly the same too. Do you know that ?
Please reply , thanks a lot....
Mysql Backup Cronjob
- How to? : / (6)
Well, I want basically a cron job that will run and backup my MySQL database. I've been told
in the shoutbox that you can do it via cron job. Didn't told me how. Now, I just want help on
how to do it and what commands I should put in the cPanel. ...
Does Trap17 keep back-ups of my MySQL Databases?
- (6)
ok, well i screwed up yes i admit it i screwed up big time... anywho, umm i was wondering is
trap17 kept back-ups of the MySQL Databases??? and if they do would it be possible for me to get a
copy of the backup for my forums sent to me somehow? because stupid me, i was re-installing my
forums, and went to make a backup of my MySQL database jsut in case, and selected all and hit make
backup, and well it only made a backup of only one of the databses, so right now i am without the
many posts i had ten minutes ago so if you so keep backups thats awsome!! youv...
How Do You Check Mysql Info, And Act According To It's Content?
- (6)
As part of a web-game on my site, I have a php form that requires people to enter their username,
and information about the characters they want to have in the game. All this information is stored
into a MySQL table. I want the players to be able to visit a page where every character they have
registered with their username can be seen. My question is simply, how can I check the values of
the MySQL data, and act accordingly? What I need to do is check for a Username and a character
number, and if it finds it, takes the data in that part and acts on it, eg. by showing th...
Database Is Deleted
- database is deleted today (6)
Today ,I access to my website and It can't connect to database,so I came to cpanel and I saw
that my database is deleted.I have a question here ,why do my database is deleted?...
I Can Not Create Mysql Databases In Control Panel Using Phpmyadmin
- Phpmyadmin says i don't have permissions to create databases (3)
I went to phpmyadmin script a few minutes ago and i could not create a database. Since it says
there on my control panel that i have unlimited mysql databases, plus i am using only a couple of
databases, please respond and fix this, please....
Trap17 Database Problems?
- (10)
is it just me or is trap17 having issues now adays? for the past two days the forums have basicly
been down except for a small period of time last night and just starting like 5 minutes ago..... is
it just me, or is everyone getting this?...
Mysql?
- (15)
My board has a mySQL error on it and when i went to cpanel it says for mySQL databases /99 instead
of 1/99 or 0/99. I tried making new one but it didn't appear after i created it /unsure.gif"
style="vertical-align:middle" emoid=":unsure:" border="0" alt="unsure.gif" />...
Looking for move, part, mysql, database, copying, putting
|
|
Searching Video's for move, part, mysql, database, copying, putting
|
advertisement
|
|