Infusion Technology Solutions Blog
Technology related solutions, tips, tricks, and other interesting topics
Posts Tagged ‘mysql’
How to Backup a MySQL Database With mysqldump
mysqldump -u userNameWithPrivileges -p databaseName > outputFileName.sql
How to Restore a mysqldump Backup
mysql -u userNameWithPrivileges -p database < outputFileName.sql
* Replace “userNameWithPrivileges” with the username of a MySQL account that can read/write to the database being backed up / restored.
- No Comments
- Tags: backup, mysql, mysql database, mysqldump, restore
Error When Compiling PHP in CentOS 64 Bit
In: General IT Info
17 Mar 2008Library files in CentOS 64 bit are stored in the directory /usr/lib64. But in normal 32 bit CentOS, library files are stored in /usr/lib so this causes a problem when trying to compile source code that looks for library files in /usr/lib. When using the default configure options for compiling PHP, the directory /usr/lib is [...]
MySQL – How to Create an Admin User Account
In: General IT Info
6 Mar 2008If you want to create an additional admin account for MySQL server, connect to the MySQL server with a MySQL client program and execute the following command:
GRANT ALL ON *.* TO ‘admin’@'localhost’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
Change the word “admin” to whatever username you want to use for the admin account and change “password” [...]
- No Comments
- Tags: admin, mysql, password, sql
About this blog
This blog is about technology related topics. It will primarily contain problems and solutions to IT problems that I encounter on a day-to-day basis. In addition interesting things I come across either on or off the internet will be posted here as well. I will also include step-by-step tutorials to common tasks people may need to do with their computers.
Web Hosting Discount
-
Get the first month for only $0.01 using coupon code HGCOUPONBLOG. No contracts, cancel anytime.
Categories
- Apple (30)
- Electronics (10)
- Games (1)
- General IT Info (47)
- Information Security (12)
- Microsoft (11)
- Ramblings (3)
- The Net (5)
- Tutorials (3)
- Web Development (12)
- Don Farland: The http_proxy environment variable is case sensitive and should be all lowercase. I dropped it in [...]
- brad: I can confirm that this works for the newest 3.0+ software. works like a charm thanks to the creator [...]
- Jim Tidmore: Hello, I believe I followed everything but doesn't connect, don't get me wrong I am not complaining [...]
- Tom: Thanks for the clear and concise information. Tom [...]
- JAUHDIMATA: good solved.. thx [...]
- How to Reset the Password for an OS X Open Directory Mobile Account
- Terminal Command for Xserve Intel Hardware RAID Card
- How to Fix a Corrupted OS X Open Directory Account Password
- How to Configure Splunk to use a Web Proxy Server
- How to Get Trixbox Working Behind a NAT Firewall
- How to Backup and Restore a MySQL Database Using mysqldump
- How to Reset the Admin Password in ColdFusion MX 6
- How to Enable ReadyBoost for an ExpressCard SSD in Vista
- Sendmail Hangs When Starting Up or When Using It with PHP
- Mysqldump Error 29
Revolutionary One Time Password Device
