How To Restore Default Settings Of Mysql
i have dump all things from A computer database to B computer database; but it replace all settings on B computer database, i want to restore all the setting of B like a default settings after installaitonl.
View Complete Forum Thread with Replies
Related Forum Messages:
Changing Default Security Settings
MySql is running fine. Installed Joomla fine. phpMyAdmin gives the following warning: "Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole." So, how to fix this in OS X? When I changed the localhost password in MAMP before nothing worked anymore.
View Replies !
Restore Default User Table
For some reason the mysql database does not contain any tables; How do i restore the default user table? I tryed to reinstall mysql: yum remove mysql httpd php php-mysql mysql mysql-server yum install mysql httpd php php-mysql mysql mysql-server service mysqld start [root@localhost] ~ : mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 30 to server version: 4.1.20 Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> show databases; +----------+ | Database | +----------+ | mysql | | test | +----------+ 2 rows in set (0.00 sec) mysql> use mysql; Database changed mysql> show tables; ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mysql' mysql> But i still dont have permission to create a new database, cause mysql database have no tables.
View Replies !
Settings In MySQL
I would like to know which settings is appropriate to set in order mySQL database to host data coming from UTF-8 pages (particularly in Greek)
View Replies !
Mysql Settings
I think I must have the settings for mysql wrong. I am using mysql 5 with php4 on apache on a windows xp computer. My problem is that I am creating a blog using dreamweaver. I create a recordset from a database and bind it to the page. Then, when i want to display some of the data from the record set, i do select etc and end up with something like this: SELECT blg_article_art.id_art, blg_topic_top.id_top, blg_topic_top.title_top, blg_article_art.title_art, blg_article_art.description_art, blg_article_art.date_art, blg_article_art.text_art FROM (blg_topic_top LEFT JOIN blg_article_art ON blg_article_art.idtop_art=blg_topic_top.id_top) WHERE blg_article_art.id_art=id_art ORDER BY blg_article_art.id_art ASC, blg_article_art.date_art DESC Now the url parameter (WHERE blg_article_art.id_art=id_art) has a default value of -1 but when I test the statement I get no data found. If i change the default value to 0 or a positive integer then one of the records is found. I have tried this with another database and get the same thing which makes me think either I have mysql set up incorrectly (although it works for all the other record sets that do not have -1) or I am very, very thick.
View Replies !
Multiuser Settings In Mysql
I have started by downloading an XAMPP server and attaching a Toad for mysql to it . I have set up a service into my machine with the XAMPP server and toad in my machine conects to my mysql correctly . Whenever I try to conect to my Xampp mysql from other machine through toad . Itr is giving me errors like 'root@newmachine is not a valid user '. How to check and configure such settings ?
View Replies !
Settings Up Mysql Administrator With 1and1
I just created a 1and1 account and configured WordPress to work with it. Now I am trying to access the backup with a GUI tool and setup MySQL Administrator on my local box. I set this up using the same settings that I entered while configuring the blog but I keep getting the error message: Could not connect to the specific instance. MySQL error number 2005 and if I press ping it says: Could not resolve hostname. Has anyone setup this tool to work with 1and1 before? Does anyone know what this issue could be?
View Replies !
Dynamically Settings MySQL Process Priority
I have written a very complex and highly CPU intensive PHP script that relies on numerous complex MySQL database calls. As this script takes nearly 48 hours to finish execution with a large database, and will sometimes be run on a live server, I need to be able to dynamically adjust the process priority of the script's MySQL thread from within the PHP code if other server activity must be given priority. Here is my question, and I know this may sound ridiculous, but is it possible to do this without having to resort to the usage of PHP's Process Control Functions? Unfortunately this is a shared host so those will not be enabled.
View Replies !
UTF-8 Settings
I would like to know if the method described below is the optimum to setup a database in order to record successfully UTF records. Should we set everything (database collation, table and even every text record collation) into utf_generic_ci?
View Replies !
Mysql Restore
I have been running a mysql backend to phpBB on my home Gentoo based linux server. I recently switched the mysql and phpBB to run on a dedicated web server on my home network. I was using mysql version 4.1.14 and then 4.1.14-r1 on my new web server. The problem is that the character set seems to have gotten corrupted during the backup and restore process. The forum is based in French and hence a lot of the special characters have gotten messed up. I have even tried copying the my.cfg file from the old server to the new one but with no effect.
View Replies !
Factory Settings
As a absolut beginner with MySQL i made a mistake and i can't access my MySQL server anymore. I have tried to erase and install it new with RPM but this didn't work.
View Replies !
Dump Settings
A primary server is running mysql 4.1. The backup is running 4.0. I have a schedules dumb from primary to secondary occuring nightly. I just realized that the import to the secondary DB is generating errors due to: ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1 Is there any setting in the primary db dump to dump the file for version 4.0? Or any other thoughts? We have anumber of things going on and have decided not to upgrade the backup mysql version just yet.
View Replies !
System DSN Settings
We have an excel spreadsheet that contains macros to connect to a mysql DB (eroDB) via the ip - 192.168.1.50. the name of the dsn is 'auto_pny', username - dbr, password and all these other details are already defined in the system dsn area. when we try to execute the statement within excel, the connector/odbc popup keeps appearing with a different set of login credentials filled in (i.e. instead of server - 192.168.1.50, it has 192.168.4.67, user - pny ...) I have to change this everytime we need to exceute the query. Is there a way of changing a setting so I don't have to keep doing this all the time?
View Replies !
Mysqlorary Settings
Is there a setting that determines the use of mysqlorary items (tables, variables etc)? As I am creating a variable @id (SELECT @id := a_id FROM table1 WHERE title = 'title';) and this appears to be fine as there is no error message (1 row fetched), but when I go to use that in the next query, nothing happens (0 rows fetched), yet I know the query is correct as if I substitute the variable for the actual number I get the result I expect.
View Replies !
Server Settings
I am using MyISAM & mainly running SELECT queries.Variable Session value / Global value auto increment increment 1 auto increment offset 1 automatic sp privileges ON back log 50 basedir C:Program FilesParallelsPleskDatabasesMySQL binlog cache size 32,768 bulk insert buffer size 8,388,608 character set client utf8 (Global value) latin1 character set connection utf8 (Global value) latin1 character set database latin1 character set filesystem binary character set results utf8 (Global value) latin1 character set server latin1 character set system utf8 character sets dir C:Program FilesParallelsPleskDatabasesMySQLsharecharsets collation connection utf8_general_ci (Global value) latin1_swedish_ci collation database latin1_swedish_ci collation server latin1_swedish_ci completion type 0 concurrent insert 1 connect timeout 5 datadir C:Program FilesParallelsPleskDatabasesMySQLData date format %Y-%m-%d datetime format %Y-%m-%d %H:%i:%s default week format 0 delay key write ON delayed insert limit 100 delayed insert timeout 300 delayed queue size 1,000 div precision increment 4 engine condition pushdown OFF expire logs days 0 flush OFF flush time 1,800 ft boolean syntax + -><()~*:""&| ft max word len 84 ft min word len 4 ft query expansion limit 20 ft stopword file (built-in) group concat max len 1,024 have archive YES have bdb NO have blackhole engine YES...
View Replies !
Cannot Restore 3.23.58 Db To MySQL 4.0.22-debug
The other day my server running MySQL 3.23.58 got hacked into and we are migrating to another one. I backed up my databases using two methods a) Mysqldump and b) copy the DATA folder on my server. Now, I am trying to restore these databases on my local machine (running MySQL 4.0.22-debug and Apache 2.0 on IIS 6.0). I have tried importing the SQL files (mysqldump) and copying the .frm, .myd and .myi files into the existing DATA folder on my local machine. In both cases, the database is created and I can see the table structure. But when I click on most of the tables, I get the following error: #1016 - Can't open file: '<table_name>.InnoDB'. (errno: 1)
View Replies !
Cannot Restore Mysql Database
My host suddenly went out of business, and deleted all my files without a notice. The only thing I have now is a week old back up Now everytime I'm with a new host, and created a new database, to restore the old one over it, but everytime I try to restore, using ssh, I get that dreadful error message: " ERROR 1062 at line 238892: Duplicate entry '189864' for key 1"
View Replies !
Restore A PLESK MySQL DB
I have a MySQL database that drives a PLESK interface, which is hopelessly corrupted. I am told that I need to restore the database from a daily dump. However, I do not have the knowledge to perform the task. I have access to my Unix environment, and I know where all the files are, but I do not know the correct commands or syntax to do the restore.
View Replies !
Mysql Backup And Restore For 4.1.x
I have mysql 4.1.11 on my current server, i need my database restore another server.. (another server mysql version is 4.1.11 same.) And now... I just created new my database to new server following command: CREATE DATABASE dbname DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci; because our database and tables uses latin5 and turkish_ci collation. How can i get correct backup and restore for this character sets? example; mysqldump -uUSER -pDBNAME > /path/backup.sql and restore; mysql -uUSER -pDBNAME < /path/backup.sql is this correct for me? OR mysqldump --default-character-set=latin5 -uUSER -pDBNAME > /path/backup.sql and restore; mysql --default-character-set=latin5 -uUSER -pDBNAME < /path/backup.sql some peoples suggest me --default-character-set= variable for mysql 4.1.x backups and restore, is this correct? also if we backup database --default-character-set option, restore command is same option will need to use?
View Replies !
Change Access Settings?
In order to access mysql I must type at the command prompt mysql --user='username' --password='password' How can I change it so that all I have to type is mysql at the command prompt?
View Replies !
The Security Settings Could Not Be Applied
when i try to install mysql on my pc it works just fine until i'm near the end of the installation, the installer writes: the security settings could not be applied error number 2003 can't connect to mysql server on 'localhost' (10061) i have disable my firewall... so whats the problem then..? please make an easy explanation... i'm not that good at english so i hope that you understand me...
View Replies !
Server Settings Error
I have my connect statments all written and everything should be working but I keep getting an error saying that it can't connect to mysql on (IP). I think this is because the mysql server is rejecting the connection attempt from the other server.
View Replies !
Can't Apply Security Settings
I got MySQL5.0 working, turns out I forgot to remove my old data files. Here is my problem. I can install fine if I don't modify the security settings, but if I do modify them, it fails saying access was denied on the root account and not using a password. If I don't configure the security settings, I can't connect to it to admin it, either by command line or the GUI admin, it always says that access was denied. I'm not sure what to do now, I've reinstalled several times and the problem keeps commign back.
View Replies !
Exception With MBCS Settings
CDatabase db; bool opened = db.Open(_T("MyDsn")); CRecordset recset(&db); //the following line work fine with _UNICODE and selects the records but throws exception with _MBCS recset.Open(CRecordset::snapshot, _T("SELECT * from MyTable"), CRecordset::appendOnly); .........
View Replies !
Database Restore / MySQL 4.1 -- InnoDB
I have got a MySQL 4.1 that we use wit vBulletin.... We had a crash last week and I've been able to restore the data up to September 2005 as it stands. Now, I'm under the impression I could rebuild the data from the logs but I cannot seem to figure out how to do that based on the tools and instructions posted. I've got my ib_log files (ib_log0 and ib_log1) also my ibdata file, which is full of all the data i'm trying to get restored. Opening it up in hex editor, I can see posts and information right up to the moment the database crashed. What steps should I take to restore the data from the log/data files? I've tried several different steps, but I'm goofing it up somewhere I guess. Are there some other tools available to help with this? This site was a 'non-revenue' site, so I didn't exactly make all of the redundancy arrangements that I would normally do for an Oracle/MSSQL or any other live business database. I'm ateast going to enable mirroring this time around and move the backups to another location.
View Replies !
Restore Root Access To Mysql
I'm another linux noob running redhat 9 and the included mysql. I had it working using phpmyadmin to configure it until I follishly removed my permisions for root trying to secure my server in phpmyadmin. Is there anyway to get this back? I've tried the grant options but I can't even logon to mysql as root@localhost. Thanks for any tips. jedihermit@jedihermit.com
View Replies !
Restore Old Mysql Data To A New Schema
I have new version of paryoll application and hence now I have to restore my old backed up mysql data (old mysql data like *.frm,*.myd,*.myi has been zipped).Unfortunately this is not easy. The new version has new schema (e.g emp_desc has been added in the new EMPLOYEE table). Wondering if their is a good way for me to do restoration. Is their any mysql tool that does this automatically or I have to programatically find out of a schema change.
View Replies !
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?
View Replies !
Unable To Restore Mysql Database
I have backed up my database using mysqldump command mysqldump --flush-logs -u root -p OM722 DB1 > db1bkup.sql Now I'm using the Mysql Adminsitrator GUI to restore the backup. It says restored successfully, but no database is created.
View Replies !
Safe Backup/restore In MySQL
This is my 1st post on this forum and I am a complete newbie to MySQL. I have installed MySQL 5.0.67 on Win XP Pro. I am using MySQL with some web based application. Which has stored data in MySQL. I am looking for safe backup technique. 1: Cold backup: What folder/files needed to be copied for cold backup? And can I restore these folders on other machines with same OS and MySQL version? 2: dump exp/imp? How can I exp/imp MySQL database into my machine and on other machines. Finally: Which one is better: Cold Backup or imp/exp dump?
View Replies !
MySQL Database Restore Error
I decided to download a db and upload it back to the server just out of curiosity. My site is now missing the top menu and components menu in the backend of Mambo. This site is for a client and I'm in big trouble here. Code:
View Replies !
Configuration :: The Security Settings Could Not Be Applied
I have recently installed the MySQL5 on my Windows XP. When I try to configure it using the provided configuration wizard, at the last stage "Apply security setting" it gives me the following error: The security settings could not be applied. Error Number 1045. Access denied for user 'root'@'localhost'(using password:YES)
View Replies !
Create User And Privs Settings
Here is the idea. I have 1 database 'a'. I want a user that can only 'SELECT' on this database, so I type: GRANT SELECT ON a.* TO 'abc'@'localhost' IDENTIFIED BY 'abc' ; After a while I get an other database 'b'. Now I get confused. I want this 'abc; user to have 'SELECT' privs on this db too, so I can do (I think): GRANT SELECT ON b.* TO 'abc'@'localhost' IDENTIFIED BY 'abc' ; But I can also do: GRANT SELECT ON b.* TO 'abc'@'localhost' is there a difference ? and is this the way to extend privs ?
View Replies !
Database Character Set And Collation Settings
I'm relatively new to creating mysql databases and have just started to build a new one for a small job i have. I've wondered this a couple of times before but just continued as everything was working ok!! What should i set the Character set / Collation values to? I'm based in the Uk and the database will be used by a UK small business if its relevant. Previously i have just used the default but when i go check the properties of the database it shows them as latin1 for Character set and latin1_swedish_ci for the collation?? Is this Ok or should i be using another value given that i'm UK based and will be putting in english characters / numerics?
View Replies !
Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only?
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar. Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
View Replies !
Can You Retrieve/restore A MySQL User Password ?
Subject: Can you retrieve/restore a MySQL user Password? I'm working on my own, local WXP, MySQL, version: 3.23.38-nt and I have the "root" password, and normally use the root account. I have forgotten one of the Passwords for a user account which I have set up. Is there any way to UnEncrypt the users password, so I can use that account again? Any handy function that the "root" account can use, to determine a user's password? OR Should I delete the account and start from scratch? OR Should I re-apply GRANT statements so as to reset user/pass info?
View Replies !
Store Application Settings As Key/value Pair Acceptable?
I noticed Wordpress uses this approach for its 'user_meta' table: CREATE TABLE wp_usermeta ( umeta_id BIGINT NOT NULL AUTO_INCREMENT, user_id BITINT NOT NULL, meta_key VARCHAR(255) NULL, meta_value TEXT NULL, PRIMARY KEY (umeta_id), INDEX (user_id), INDEX (meta_key) ) --------------------------------------------------------------------- umeta_id user_id meta_key meta_value --------------------------------------------------------------------- 1 1 nickname Admin 2 1 wp_user_level 10 3 1 wp_capabilities a:1:{s:13:"administrator";b:1;} --------------------------------------------------------------------- 4 2 nickname site admin 5 2 wp_user_level 1 6 2 wp_capabilities a:1:{s:11:"contributor";b:1;} --------------------------------------------------------------------- I wanted to use a similar approach: CREATE TABLE user_meta ( user_id SMALLINT UNSIGNED NOT NULL, meta_key VARCHAR(20) NOT NULL, meta_value TINYINT UNSIGNED NOT NULL, PRIMARY KEY (user_id, meta_key) ) ENGINE = INNODB; INSERT INTO user_meta (user_id, meta_key, meta_value) VALUES (1, 'allow_description', 0), (1, 'allow_email', 1), (1, 'allow_website', 1), (1, 'allow_map', 0), (2, 'allow_description', 0), (2, 'allow_email', 1), (2, 'allow_website', 1), (2, 'allow_map', 0), Would the above method be acceptable or is there a better method? The above method just doesn't 'feel' right,
View Replies !
ERROR:Using The Mysql Client On Freebsd To Restore A Mysqldump??
I cannot figure out how to resolve this error, can anyone point me in the right direction? mysql: Out of memory (Needed 182246856 bytes) mysql: Out of memory (Needed 182242760 bytes) User time 66.66, System time 36.05 Maximum resident set size 526660, Integral resident set size -2117839848 Non-physical pagefaults 2585767, Physical pagefaults 1, Swaps 0 Blocks in 11195 out 0, Messages in 2628 out 2694, Signals 0 Voluntary context switches 176407, Involuntary context switches 11071
View Replies !
MYSQL Database Alteration, Repair And Restore Takes Huge Time
I am trying to run alteration queries on one of my mysql tables which has more then 22,00,0000 lakh records. Its been 23 hours and the process is still running (I have to close all the sites running on server due to same). My server specifications: Red Hat 9.0 Pentium 4 3.0 GHz 2 GB Ram, Burst RAM 5 GB Running webserver, mail server as well. Is there a way I can view the minute process details, as what table record is being updated ?
View Replies !
MySQL Default Value
When a customer places an order, the database sets the default at "3" which means "not complete" when it is complete and billed, It is assigned a "1" I want to have it be assigned a new number on all future orders, but no not want it to go back and reset every single past order. If I change the default value number in the database, will it only apply to new orders, or will it change every single record to the new default regardless of their current status?
View Replies !
|
TRACKER
