Transfering Another Db Into MySQL Admin
Is there anyway to upload a database into MySQL that is not a MySQL database.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Transfering Mysql
i need to transfer my entire mysql database in order to keep my sites php message board/forum information/posts from being erased off the board. is this possible? will i have to download the database onto my computer first?
MySql Database Transfering
I recently got a new host and I want to take my blog from my current host and move it to my new one. I am not really sure how to go about doing this. I use pLog for my blog and im I think I have to use the installation.php again, but I'm not sure how to take my MySql DB and put it on the new server. Do I have to remake the DB or what?
Need Help Transfering Database
I am transfering to new hosts but I want to keep all my foru database, how can i do this, i supose I need to export it in phpMyAdmin and then import it? Am I right?
Transfering Data From 4.1.7 To 3.23.58
I have two MySQL servers, one is running 4.1.7 and the othe 3.23.58. I have tried to transfer data between the two machines but somewhere in the process something happens to the data in the tables. Some characters are changed/added, things like à etc. I'm using mysqldump to create a sql file on the 4.1.7 machine with the parameters --opt --compatible=mysql323. If I check the file manually the data is still correct. When I insert the data again on the 3.23.58 server the characters get changed/added. I have checked the character-sets on both servers, they are both set to latin1. Any ideas on how I can import the data without the changing and adding of the characters?
Transfering Information Between 2 Different DBs
i have an old DB done for a forum in the mambo system ( now called joomla ), but i am changing now to vbulletin system + vbadvanced. The DB i use is MySQL in both forums, but when i open the backup file from mambo and compare it to the vbulleting DB using my phpdev system, i see that they are tottally different. would you have any tip for me so i can save at least my users and their information from mambo to vbulletin? Can someone help me? It´s a very seriou forum, it´s from Alias ( 3D Maya Software productor), and so, could please somebody give me a tip? A help? A force to make me win my MySQL battle?
What Do You Use For Mysql Admin?
what you all use for mysql administration? i know learning for the command line is essential but sometimes that takes too long and a gui is needed. I've been using phpmyadmin forever. is there anything else out there faster better more useful?
MySQL Admin
have just installed it and am having no luck getting past the Server Instance. I put in the Server host as "localhost, the Username as"root" and the password I created at the beginning. I hitOK and I get this message... "Administrator for MySQL Servers has encountered a problem and needs to close. We are soort for any inconvenience." I made sure that Port 3306 was available.
Best MYSQL Admin
Besides PHPMyAdim, What is the best, easy to use, administration tool to use on a windows machine. Gui type? Also free?
MySQL Admin
I am having problems with my DB, basically i am not able to load mySQL Admin script in Ensim. First where is the location of the mySQL Admin script because in the spot i expect to see it there is no folder.
MySql Admin
When I boot my computer the MySql Admin window appears on the desktop. The only way I can close it is my clicking theHide Me button. I get fed up of this routine everytime I boot the computer. Does anyone know there is a way of keeping this window hidden so that when the computer is booted up it doesn't appear.I don't use MySql admin anyway as I connect through PHPMyAdmin.
MySQL Admin
I created an instance using "MySql Server Instance Config Wizard" then opened MySql Administrator, where I was asked to supply a user name and password for the connection. I did not supply a user name creating the Instance. Is there a default user name? How do I login? Windows XP OS
Transfering Records Between Tables
I have two tables 'gamestats' and 'gamestats_archive', i want to move x records from gamestats to gamestats_archive and then delete the records that have been moved from gamestats. Here is the queries that I am using: first this runs: INSERT INTO gamestats_archive SELECT * FROM gamestats WHERE date='$selecteddate' ORDER BY entry_id ASC LIMIT $maxstats then this one: DELETE FROM gamestats WHERE date='$selecteddate' ORDER BY entry_id ASC LIMIT $maxstats the problem is that the delete query is not deleting the records that have been moved, its deleting different ones. does anyone know why this might be happening?
Transfering From Godaddy To Hostgator
I have been with godaddy for almost a year and my hosting is about up. I want to move to hostgator so I can have a cpanel and continue learning. I am having a horrible time getting my databases moved. There is a compatability issue. Hostgator went and converted all but one. I have two issues. I go to config my wordpress and it only works on the index but not the blogs in the site.com/thisfolder. Also godaddy emailed me this one database because it was not accessable to me user_45319205-11-07.sql "-- MySQL dump 10.9 -- -- Host: 10.0.11.206 Database: user_453192 -- ------------------------------------------------------ -- Server version4.0.27-max-log" This I guess is not compatable with hostgator how can I take this .sql and make it so I can put it on a database on hostgator?
Transfering Database From One Computer To Another
I am working on a personal site and have been usqing an MySQL database I created. I have transfered databases before by simply copying the database file itself (from the data dir) and putting it on a flash drive, then throwing it back in the data file on the other computer. Currently however I am getting this error... I can USE the database, I can even see what tables it holds, but when I try SHOW COLUMNS FROM users; it gives me this... ERROR 1146 (42S02): Table 'tome.users' doesn't exist. I have tried everything, from re-installing MySQL to checking permissions. I had a similier problem a while ago but I cannot recall how I cleared it up.
MySQL 4.0.xx Admin And Usage
I've recently taken over my non-profit's Web site design, administration and maintenance with relatively little MySQL experience (although I have learned a great deal very quickly). My question is, does anyone know where I can get a manual or something like the current manual "Building your Own Website Using PHP and MySQL .."(ordered from sitepoint.com site). This manual is basing the MySQL on the most current version of 5. I'm looking for something similar that addresses the 4.0.xx(27 specifically) of MySQL
Admin Tools For MySQL
What admin tools do you recommend for managing my MySQL databases. In the past, I have used DB Tools, but now its not free, http://www.dbtools.com.br/EN/dbmanagerpro/
How To Set Up An Admin Password On OS X For MySQL?
I use to use Complete MySQL, I decided to use MySQL from here, just do to the fact of the major bug that C.MySQL contains now... But the problem I am finding with the documentation is that it doesn't explain in OS X, how to create the admin account, and how to give it a password as well..
Special MySQL Admin
Im looking for a solution to create a limited numbers of MySQL-Databases. In other words a front-end for users. The software AutoControPro (www.directphp.com) has this feature, but is very expensive to buy the soft only for the My-SQL feature. I should have the possibility to limit the Databases for every user and the user should have the possibility to create the appropriate numbers of Databases. Example: User1 can create 3 MySQL-Database User2 can create 5 MySQL-Database If the User installs phpMyadmin he should get only the assigned Databases.
Admin User In MySQL 5.0
I've just installed MySQL 5.0 on my sun box (runing Solaris 10, install from blastwave). This is my first time with MySQL so I don't have any exp with it. I have some troubles as: - I set password for root account via this command: # mysql -h atlantis -u root mysql mysql> update user set password=PASSWORD('123456') where user = 'root'; mysql> exit However, I can login again with root account without pass check ???? - Next, I create new user name admin # mysql -h atlantis -u root mysql> create user admin identified by 'admin' ; mysql> create database newdb ; mysql> GRAND ALL ON newdb.* TO 'admin' IDENTIFIED BY 'admin' ; Once again, i can't use admin account to login to newdb database?
Trick MySQL Admin
There are a few features in mysql administrator that are only available if you are connected to a localhost...this is useless if you are using a remote web server, linux based and need to monitor some of this information. Anyone have any idea if there is a way to allow the following functions to work without local host? Service Control: Start/Stop Service, Configure service Startup Variables Server Logs: Error Log, Slow Query Log, General Query Log
MySQL Admin Backups Won't Work
I’m using MySQL Administrator and MySQL Query Browser and want to make a backup of a database. First you click on the “New Project” button and name the project. Next the documentation for MySQL Administrator says… “To choose the databases and tables that will be backed up, select the database from the schemata list and click the > button. Once the database is in the Backup Content list, you can un-check specific tables that you do not wish to back up. “ That sounds straight forward enough – it works like every other gui out there. The problem is you click on the database you want to backup and it doesn’t become highlighted and when you click on the”>” button, nothing happens. Why?
MySql Admin Schedule Backup
Mysql Admin 1.1.9 (server2k3) I would like to schedule a backup of my db with MySql Admin. The concept is fairly easy but I probably miss something since the schedule backup is not running... I've created a new backup project - named the project - Selected the db I've selected InnoDb Online Backup left everything default Last I've set a scedule backup every day at 23:00 with a target folder and file name Do I need to do something more ? The scedule task is not running at all, the only way I can backup my db is by running it manually.
Error 1064 In MYSQL ADMIN
I am trying to run an SQL script using File -> Open Script. Everything is working fine until one of the INSERT commands has a backsalash insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('9', 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language's currency when it is changed', '1', '10', NULL, '2004-11-03 12:36:43', NULL, 'tep_cfg_select_option(array('true', 'false'),'); In the code above the word "language's" seems to be creating an error. How do get round this problem?
Restore From Backup With MySQL Admin
I am trying to restore a mysqldump txt file to another cpu using MySQL Admin. I receive an error: The selected file was generated by mysqldump and cannot be restored by this application. I understand there are other ways of transfering a database to MySQL on a different cpu. ie. mysql -u Username -p DBname < Filename.sql When I try this it doesn't work I'm doing something wrong. Does the "filename" need to be an exact path to the file or just the file name ie. C:folderfolderdatabase.sql Also does it matter if the file is .txt or .sql? Does it matter where I have the database.sql file on my computer? Do I need to have a new empty database created?
MySQL Admin Scheduled Backups
Two problems: 1.-- MySQL Administrator will do backups manually and for sometime it did scheduled backups, as well. Now a scheduled job will fail and generate an event id 1000 error: Faulting application MySQLAdministrator.exe, version 1.2.3.0, faulting module MySQLAdministrator.exe, version 1.2.3.0, fault address 0x001e5342. 2.-- The SQL error logs have disappeared since starting the use of Administrator for backups. Is there a way to get them back or at least start the recording again? The only thing that ever showed up in the logs was the shut down and start up of the MySQL service at the beginning and end of a flat file backup of the entire database. Still... it would nice to have the logs back.
MySQL Admin InnoDB Backup
I'm having trouble backing up my InnoDB tables.The structure is backed up but the data isn't. I've tried every option that MySQL Admin offers. Does someone know of a solid way to backup InnoDB tables whithout bringing the database offline?
MySQL Admin Program/Script
I'm looking for an application, or php script that makes entering and retrieving information out of a database automated. The process would like so: I enter in the mysql un/pass etc. and create tables and rows. Also defining what type of input each row should have. Whether it be a checkbox, a dropdown menu, plain text input. Also defining what options for things like the checkboxes and dropdowns. After that, you would be able to go to a simple front end that had the inputs you defined. You could create your entries and retrive them. Sorting them how you see fit. Given the obvious use for such a thing, there must be plenty. I must not be wording my searches correctly though. I would prefer something free/open source.
Backup Options Non Functional - MySQL Admin
I have inherited a small MySQL database, version 5.x. I have installed MySQL Administrator. I would like to try the backup utilities offered in this application, but they are all greyed-out and non-functional. It doesn't matter whether the application is run on the local host or on a client workstation -- the backup features are non-functional.
Transfering Database From Local System To Live Server
I have a site running locally on my notebook and I copied my site to a live server. I have no problem getting the PHP & HTML files to the server, but i'm not sure how I can move the database and data to the live server. Can I copy a file to the live server like I can with an MS ACCESS database? Or do I need to recreate the whole database on the live server and somehow figure out how to transfer the data?
MySQL GUI Tools Query Browser/Admin Login
I've just installed the GUI tools so I can get a little help with queries and table design, and I am not able to log into the administrator or the query browser. The login screens show up, I enter all the correct data, then the form grays out except for the cancel button and does nothing. Doesn't even eat up any system resources, so it doesn't even look like its trying. I've turned off all firewall settings in case that might have cause the issue and it still doesn't work.
MySQL Admin - Lost Thread On Specific Like Query?
mySQL win32 (4.0.22) I am using mySQL Control Admin and seeing a lockup on a thread specific to a like query. select * from table1 where field1 like 'http://h%' limit 100 This request will sit (thread) forever and never return any records. (status : sending...) However : select * from table1 where field1 like 'http://h%' limit 100 returns records immediately, no problems... I have already run : /mysql/bin/myisamchk --sort-recover dbtable1, no errors, no problems... How can I tell what this thread is really doing or if any additional problems exist with this table using myisamchk?
User Admin In Mysql-administrator Slow On Linux
We have a MySQL 5.0.16 server installed on a RedHat 8.0 machine. mysql-administrator v1.0.22 is installed on RH Linux FC3 from the mysql-administrator-1.0.22a-1.rh9.i386.rpm. Everything seems to run fine except User Administration is *extremely* slow. If I click on "User Administration" in the sidebar, it takes about 2 minutes (seems like forever) before the window comes back with the infomation. All the other functions seem to function fine. Is it because I'm using mysql-administrator on a remote host? Do I need to move and rebuild the server to a newer Linux version? mysqlcc doesn't have this problem at all. (It's using the libraries from MySQL 4.1 that the databases were migrated to.)
Why Can't I Log In As Admin?
I am using MySQL 5 with PHP 4 on localhost. I was able to login fine yesterday as root but this morning I was unable to. When I type my password in the client it just dies. I know this is a very general question. If anyone is familiar with PHP, this is the error I get Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:wampwwwLivemysql_connect.php on line 8
Php My Admin
I recently started using PHPMyAdmin, just figured out that it goes to XAMPP's MySQL/Data folder... with the extension of MYD I have some questions 1) Where can I get a free MYD database reader/editor not free trial but free 2) I have a bigger problem with PHPmyAdmin I create 2 Fields: Name, Comments but when I create it , it does not show me the table... How am I suppose to edit the records in the fields? I know I can, I just dont know how... 3) Some basic questions: a) how to make an input mask b) how to make an ID that is in MDB called: Autonumber 4) Is there an editor for MySQL databases like Access and is MySQL Server 2005 one of them? if not what does it do?
My Admin Accesss
I'm new to SQL server and having an issue. We have databases stored accross two machines. The structure and records can be accessed by authorised users through the myadmin page. This points to 1 server and its databases and directories can be viewed but I also need the databases on the other server to be viewed through it aswell. I can't see anywhere on the myadmin page which will allow me to set this up.
Web Admin Page?
is there a web admin interface that is included when installing MySQL? If so, what is the url (e.g. http://localhost/mysqladmin)?? I am getting into programming in PHP and want to use MySQL on my development machine (they will both be on the same box to run concurrently). It's a Windows machine running IIS 5.0
ENUM And Php Admin
Creating database in mysqlusing php admin, if I pick the datatype Enum and the if I have values for enum 'view' and 'url' . Where do i put these values. I mean would it be in Length/Values colum or attributes?
Remote Admin
how can i remote admin the mysql (i am using mysql 3.23.) and how can i create users for the remote control (using phpmyadmin 2.2.6)
Assign Admin
Is there a way to have a user in MySQL to be able to add databases, create users, and full access to the databases he/she setup? But not being able to access the other databases on that same server. Also being able to add users whenever they like.
ENUM And Php Admin
Creating database in mysql using php admin, if I pick the datatype Enum and the if I have values for enum 'view' and 'url' . Where do i put these values. I mean would it be in Length/Values colum or attributes?
Php Admin Tool
I recently upgraded from phpmyadmin 2.5.0 to 2.6.3-pl1. I cannot find the functionality to 'load text files into tables'.
Admin Rights
IM RUNNING A PHPBB FORUM WITH MYSQL...PROB IS NOW SOME GUY HACKED INTO MY PHPBB FORUM AND CHANGED MY ADMIN PASSWORD..NOW A FRND TOLDME THAT I HAVE TO GOTO MYSQL AND RESTORE MY ADMIN RIGHTS /I HAVE TO MAKE A NEW ADMIN ID..NOW CAN SOMEONE TELLME HOWS THAT DONE
Create An Admin User
I need to create an admin user for my mySql database. I am using phpMyAdmin for a manager.
Admin Login Not Accepted
I am trying to setup third-party php software on a hosting domain. I have no trouble at all setting up the communication with the mySQL database, and the software creates the needed tables in the database without trouble. Only when I am done, it is not accepting my login in the site structure. I have asked support by the developer of this third-party software but after trying several solutions we have come to the conclusion that the error does not lie within the third-party software. I have tried several times to make changes in the database, deleting it, make anew, do reinstall on the third-party software, completely delete and re-upload third part software all resulting in the same error over and over. It says im not a member (even tho account is in database and is active) or my connection has timed out. Perhaps anyone can shed some light on why I cannot log in to the website structure with my freshly created admin account even though the tables within the database as well as admin account have been created.
Admin Focused Book
I am looking for a good MySQL book with in-depth coverage of Administration topics. Something written for a DBA, not a programmer. I am trying to expand my skill-set and cannot for the life of me find any books that go into detail enough on Admin Tasks. I was in a few local book stores this weekend and could only find books geared towards the programmer or first time SQL user. That part I know already.
Need To Create A Limited Admin User
I need to create an admin user with limited rights who can create databases and then grant full rights to these db to another user. If I give the admin user full root privileges (grant all on *.* to 'user'@'localhost' identified by 'pw' with grant option) it works, but I don't want to do this for obvious reasons. What privileges does this admin user need to do just these tasks?
GUI Admin Console Login Problem
This is a follow-up to thread436-1281656.I successfully installed MySQL database engine.I can access the database from the command line without any problems.I used the standard MySQL username and my own PW. I then installed the MySQL GUI features such as the administrator.I started the server, from windows, and tried to login.However, it will not let me.I am running locally and used localhost.I am including the screen shot of the Admin and failed login. I am able to ping the box successfully by pressing the ping button.
Machine Name & IP Address Fails For Remote Admin Login
I've just set up 5.0 on both a desktop server and a laptop with an essentially default install using WinXP (brand new, naive user here!). I find that when I use the Administrator Tool that I can only log into ServerHost: "localhost" using Username: "root" and the password I made. This is made worse as I can only hit the desktop from the laptop using Remote Desktop connection. What I can't do is either use the WinXP machine name, or the IP address for the Serverhost. This becomes an issue for the laptop especially as the IP address can change (although this is accessed through a VPN, so the WinXP machine name might be used). I am quite confused by the documentation regarding servernames, bindings, hostnames, etc.
First Time Install On Windows - Admin User&password Problem
I have a problem with logging in to MySQL. Access denied. I think the issue is with the host, user and password settings. I assumed you had to add this information to the my.ini before you started the service for the first time. Is this only for WinMySQLAdmin? Is there a default? I have tried all the solutions I could find but they seem to all require user privileges in the first place. I simply need to have one main admin user and password and to refresh their values to be certain of the new settings in case there was one before.
|
TRACKER
