Secure Backup On Win32 Systems?
mostly for unix platforms.
On win32, what is the best way to run a secure mysqldump so that my
password doesn't have to live in a script somewhere?
I'm using perl scripts to kick off my backup commands.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Secure Backup On Win32 Systems?
i know items have been posted before, mostly for unix platforms. On win32, what is the best way to run a secure mysqldump so that my password doesn't have to live in a script somewhere? I'm using perl scripts to kick off my backup commands.
How To Access The Last Entry For Different Systems
How would I access the values of the last datetime stamp for different system id's present in the table? For example, if i have 5 system id's their last entered datetime stamps might be different. How would i access the related values for the systems?
Non Networked = Non Secure
mySQL looks good for a Network. BUT as a standalone it is not secure.Open anytable.MYD in a hex editor and you can see the data.So we can't sell our software to clients on wind98. Believe it or not we have had a lot of success selling software with a proprietary database where the data is in 'unusual' format. Clients are happy because casual snoopers can't see personal data,and we dont promise "strong" security. Security through obscurity works!I wish mySQL had even a touch of obscurity in its MYD files.
Replication Secure
I'm about to jump into the world of mysql replication, but am wondering if the connection between database servers is secure seeing as how they will have to communicate across the internet.
Transaction Secure Code
When executing a specific query, I need to lock the db to ensure that no data is altered while the query executes. My question is: Do I need to take a ROLLBACK on the db to release the lock, or is it enought just to set autocommit=1 again? Simplified example of how I do it now: SET AUTOCOMMIT=0 BEGIN SELECT .......bla bla bla <execute some php code based on the result> ROLLBACK SET AUTOCOMMIT=1 Example of how I want it to be: SET AUTOCOMMIT=0 BEGIN SELECT .......bla bla bla <execute some php code based on the result> SET AUTOCOMMIT=1 Are there any downsides by not using ROLLBACK in the second example? The database has not been altered in any way.
How To Secure My Mysql Database From Others?
1) if somebody else knows my mysql database username and password ( username with all permissions ) can they copy my database even if they do not know my control panel password? 2) Suppose I have placed my database username and password in a .php file in my file manager not in the admin folder, is there any possibility for others to steal my username and password? 3) what steps should I take to secure my mysql database from hacking and all such unwanted dangers.
Designing A Secure Database?
I'm working on a website/database deal, and right now I'm designing the security model. It's using LAMP(HP), so all the tricks are going to be through PHP. First off, this will be behind a firewall with SSL encryption. We may also setup some kind of VPN tunneling.I'll be ignoring other security details that don't apply to the problem at hand, but please feel free to suggest. I'm going to have users enter a username and password, with PHP emulating the htaccess dialogue boxes. I would like to check the entered values in a permissions table. This table looks like: username | passwordhash | ipaddress | permission All users will have a static IP, so they have to match the username-password-ipaddress combination. I'm storing the passwords as an MD5 hash in case someone breaks in and reads the table. So what MySQL user does PHP log onto as the database as, in order to read the permissions table? (After that, we just go with the logged user's permission). If I make a special user that just has permission to read the permission table, do I have to store that user's password plaintext in a php script somewhere, thus adding a security risk if someone were to get a hold of that password?
Making Secure Database
how would i go about making my database as secure as possible so users information is kept as safe as possible.... at moment i am using md5 encryption for their passwords... does any1 recommend anything else ?? and also in general to keep my data as safe as possible..... will web hosts deal with keeping mysql database secure or should i do sumting against it?
SQL Query Works Only In Win32!
I use MySQL from my php page and from phpMyAdmin. In Windows Server, following query works fine. In Linux Server instead it returns error. The SQL Query is: SELECT DISTINCT a.id, a.container, b.container FROM folder AS a JOIN folder AS b ON a.container=b.id The PHP error is: You have an error in your SQL syntax near 'ON a.container=b.id' at line 1 So, I ask: If in Windows this query work fine, where is the error in the Linux version?
Perl, DBI, MySQL And UTF-8 Under Win32.
finally I succeeded in inserting Unicode (namely utf8) strings into a MySQL database, but what I still don't know is how to query the database to avoid getting ? instead of e.g. ?. (áéö works somehow, since they are among latin1 (iso-8859-1) characters). Code:
MySQL 4.1.14 On Win32 Just After Install
Here is what I get when I try running MySQLShow: C:Documents and Settingsmorla_jb>mysqlshow mysqlshow: Access denied for user 'ODBC'@'localhost' (using password: NO) Any idea?
Make Win32 Installer NOT Always-on-top ?
I noticed that the windows installer wizard window is always-on-top, which I find very annoying. Other install wizard don't behave like this. Is there a way to turn it off ? I used the file mysql-essential-5.1.12-beta-win32.msi on WinXPproSP2.
MySQL Win32 Install
I've downloaded MySQL community server, the one without the installer, and I've unzipped it into c:. The last time I tried, I downloaded the one with the installer, and well.. I'm entirely newbie so once I did the installation and configuration, the computer start progressively work strange until I had to install windows xp again from zero. I need to install and configure the MySQL database locally, I mean I don't want it to connect to internet. I'm trying to install a weblog server application in this computer but I don't need the weblog to connect to internet, just work into the computer. I don't know nothing about server configuration, databases and things related. Therefore I would like some help configuring MySQL to work locally so the computer OS wont be in danger.
MYSQL + Win32 = Difficulties
I've a newbie to MySQL. I've installed it on Windows and assigned a password to the root user. Now when I log in I do the following: C:mysqlin>mysql -u root -p Enter password: ***** But all I get is: ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) I can't seem to find an answer as to why i'm hitting this problem. Can someone please explain?
Running MySQL Win32
I'm an absolute beginner and would really like to read something in the manual to solve this problem, but the manual just take care of Unix and Linux users. Because we develop on NT we wanted to install MySQL with Apache and PHP3 on a NT workstation for faster testing beside our Linux station. But I have problem to start the program (mysql.exe). It just gives back an error: Error 2003: can't connect to MySQL server on localhost 10061 Network is running, I can ping localhost. I don't know what to do to get it running.
Troyan.Win32.Zapchast.d
my antivirus (kaspersky) say: c:mysqldatahvocd.dll is a Troyan: Troyan.Win32.Zapchast.d i have winXP home and mysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32) can this file be infected by this troyan? can someone send me the original file hvocd.dll?
From Test Environment To Secure Commercial Use.
I'm relatively new in the database administration field. Uptil now I've only tried MySQL together with PHP in a test environment. I would appreciate if someone could answer a couple of question, I have regarding commercial use and a secure professional configuration. Uptil now I've used XAMPP as my installation on my own computer on localhost. Now we'll install the same software package on a server. I guess XAMPP and PHPmyAdmin is not a professional setup right? Questions: 1. What is the best recommended and professional setup for commercial use? 2. What is the best GUI for the database? 3. What is Frontend and Backend? 4. Backup setup? Just if anyone have some recomendation. I've built a web based dynamic Content Management System in PHP and MySQL for internal use. Using the localhost as the developer platform. I've never before built something like this for commercial use. 5. How do best implement this system on our companys server, so we all can use the system?
Mysql 4.1.16 Win32.msi Error Message
I have downloaded mysql 4.1,16 win32.msi for use with sam broadcaster. The download and set up were successfull but when I try to execute I get: mysql can not start error 0.
Installing Mysql-noinstall-4.1.11-win32.zip On Windows XP
I unzip the file "mysql-noinstall-4.1.11-win32.zip" and extracted to " C"/mysql then, i did a "c:mysqlinmysqld --console" The "red light turned to green light on the mysqladmin" so, i assume mysql is connected. when i try to test the mysql by "phpinfo() " The information about mysql didnt not show up on the firefox. Does anybody know why? any configuration that i should do?
Backup MySQL Via Port 3306 (which Tool? Automatic Backup?)
i have quite a big database on my website - and i cannot get any backup via system dump or scripts anymore, because my hoster added some memory limits - and scripts/dump can't finish... so the only way left is to backup my database via connection to port 3306 and tools like mysqlfront. mysqlfront is unfortunately quite slow and buggy - so do you know any tools which can backup databases via external connection? - it would be great if there are tools which run automatically? (batch/commandline??) backup with mysql.exe - h -u .... is impossible, too!
Mysql Mysql-4.1.10-win32 Problem
I installed <b> mysql-4.1.10-win32</b>in the place of mysql 4 beta ..after my installation i am getting the message which when i try to connect php into mysql the message is Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
Free Mysql GUI Mysql "client" For Win32
I'm currently working on re-engineering a web stack completely to use mysql as a back end instead of (shiver) a bunch of Access files. I've used mysql for years both personally and professionally, but being a UNIX dork I've almost exclusively done so from the command line. Whenever I've needed something a little more user-friendly than that, I've installed a web tool like phpmyadmin. However in this case, I'm working in an all-Windows shop (mostly server 2003) and I know that I'm going to be passing this on to someone in a couple years. As I document various tasks, I'd like to use a desktop client with a GUI interface for doing things like "browsing" the database, modifying stuff now and then, etc. I see that mysql.com has a nice "administrator" and "query browser" available and they're pretty nice - but neither is really what I'm looking for in terms of something that has a GUI interface and actually manipulates the data itself. Unfortunately I cannot count on a successor knowing much SQL or being comfortable on the command line. I'm guessing there are many free tools out there but would love to start out on whatever people who already love to use such things find the most mature, featureful, easy to use, etc. So, suggestions?
Backup
How do i make a backup of my database structure without the actual data in them. I have a couple yrs worth of data stored and would like to just back up the actual tables with no data... Can this be done from within the MySQL administrator program?
Backup
I have my DB hosted somewhere, but it's a hosting center that has no phone number. Nehow, if I have a MySQL DB with like 6 databases and many tables in each DB what would be the best way for me to back it up? If you have a hosted DB, and let's say you loose data, how do you regain it? Is backing up usually done manually, or is it done through software like backupExec or something? In the context of this being hosted. Yes i konw i need to change ISPs, but I want to know the process first. Also, if you ask ur ISP to do a rollback, is there a fee for this? A future ISP of ours charge 25$ for it.
Backup Db
I just started using MySQL yesterday, so I really am incompetent about most of it. Where is my db being stored and how do I back it up?
Best Way To Backup
Is there anyway to backup mysql without grinding the site to a halt while it runs? I've moved it to 3am but it can take a long time and if there are still visitors on the site then they cannot search while its running.
Backup
I'm trying to create a backup.bat file to do my backups. In my test .bat file I have: mysqldump -u root -p password database >backup.sql Obviously this command is failing because I am asked for my password each time I run the bat file, then is says it can't find table "password."
Backup DB
how or a program that can turn .frm, .myi, .myd files into .gz files or how to extract or make a importable file with all the info from them without mysql installed on windows? I deleted the program thinking i wouldnt need it anymore and now I need the information from the files but cant get mysql to work again.
Getting A Backup
we started using a doc management system that requires MySQL. Therefore I need to find out the quickest and less error prone way to create a backup of my MySQL databases. I found some nice resources on the net, but most already start telling me that method x works only for table types a and b, while method y is for table type c only. So first question would be how to find out which kind of table types I have in my database (as they were created by the application, not me).Any other hint on how to get a fool-proof backup (*cough... also easy to restore) would be very much appreciated. A small downtime of the databases (e.g. write lock) is not a problem, as our netapp can make a volume snapshot in matter of seconds.platform
Backup
I am hosting a website at a hosting company. I have Mysql database, using phpMyAdmin 2.5.1. How can I make a back up of my database?
Backup
Is this the correct command for restoring from the mysqldump backup?? Code: mysql -u <<username>> -p <<password>> <<database's name>> < backupfile.sql
Backup
I'm an Access user who's looking to have a RDBMS with a more robust back up system. We have a rather big project coming up and so far, we're planning to use Accesss. But I'm thinking about making the switch to MySQL. It will be in a multi-user environment (however, only a few users will be writing data). But many others will be reading. Overall, I'm rather inexperienced when it comes to backing up transaction logs. This is my question. Say a user accidentally deletes half of the records in a table. Then more records are added and many are updated. Then three weeks later, somebody realizes that half of the records have been deleted (the accidental deletion mentioned above). So is it possible to go back in the transaction log and find the delete 'transaction' in which the said records were deleted? Then is possible to 'undo' that deletion? What about all of the valid inserts and updates that were made after the accidental deletions. Will those be preserved? In other words, is it possible to undo individual tranactions/operations without affecting the transactions made after then?
Database Backup
Well i don't really know if this should be posted here, as i use mysql along with php but i believe it is more relevant to mysql forums. Is there any way of automatically backing up a db, say once a week? Kind of a programmed process lets say..
How To Resotre The Backup
I have my old backup of my whole site (which i taken on 7-24-2006) Now i want to restore that backup means the databse data. Actully i want to resotre the database of 7-24-2006. How can i resotre using my cpanel.
How To Backup Database?
I have mysql and a single database. I'm moving from one host to another. I was instructed to "backup database from old host and restore in new"
Backup Question
by using mysqldump, is it possible to save all table in different file, so instead of having 1 big backup with table_a, table_b and table_c into a file called backup.sql, I would have table_a.sql, table_b.sql and table_c.sql ??? Also, on MySQL dev site, they said to use mysqlhotcopy instead of mysqldump if all table are MyISAM as it is faster. Did someone use this as it is the first time I see that?
MySQL Backup?
i mean. It is easy to restore a database I use that mysql_tool.php script. But what about backing them up? It is impossible to download a 200 MB database from phpmyadmin. Haven't anyone made a tool to backup the file to the server itself? That mysql_tool.php only have one problem, it doesn't work in newer MySQL versions. But it is a very cool tool. Try using it. I really need a tool to backup a database without thinking about size.. Download it here: http://hiveworkshop.com/mysql_tool.tar.gz
MySQL Backup
1. You can shutdown the server instance, and copy the Data folder to a backup location. 2. Use Mysqldump to to dump the Db into a text file, that can then be fed into a clean db, to restore the Database as it was. This method has the benefit that you don't need to shutdown the instance to run it.
Backup Woes
I am trying to backup a big database of my site (around 500-600mb), so directly dumping to a .sql file takes over an hour on my server and its just not the best way I tried using mysqldump --tab=/path/to/dir --opt db_name -uuser -p, but I got this: mysqldump: Got error: 1: Can't create/write to file '/home/httpd/xxx/httpdocs/folder/file.txt' (Err 13) when executing 'SELECT INTO OUTFILE' I read that its because mysql user has no write priviledges. I tried chown and gave the folder root ownership, and tried to use the mysqldump with u = root but I still got the error. What am I doing wrong here?
Backup Problem
I must make backup each day at midnight and I use mysqldump. I have 4 many big tables and the backup is long (10 minytes). So, I don't stop my web site during backup but mysqldump lock my tables and all queries are blocked during 10 minutes. How make a backup without locking my tables?
MySQL Backup
I'm trying to set up daily backup of MySQL server through Webmin. I've set the backup location, and backup works just fine, but I would like to (if possible) have a separate folder named after the date. My backup location is /backup/mysql, so what would be syntax for dated folder ... so I would have /backup/mysql/20.11.2005 or /backup/mysql/20112005 ..
Where Does The Backup File Go?
I cannot find the msqldump backup file after issuing the command. When I do a google desktop search it does not show up. I've looked in the bin folder, the data folder, the mysql 5.0 server folder -- alas it is not their. Here is the command I issue >mysqldump -u root -p naasf > nasskbak.sql I then get the following >password: I enter the password, about 3 seconds pass, and then the dos prompt returns. I assume the dump file is being made, but I can't seem to find it. BTW, I did check the PATH variable and it is set the mysql server bin.
Doing Differential Backup
Does any know how to do differential backups or does exist a tool that do this kind of backups. I have mysql 4.0.12 and use innodb tables, mysql is running on redhat 7.3
|
TRACKER
