Sometimes you need to dump a single table from a mysql table and restore it somewhere else. Here's what you need: 1. Dump the table (compress it so it will take shorter to transfer over the network) mysqldump -h <HOST> -u <USERNAME> -p <DATABASE> <TABLE> | gzip >… Continue reading
Let's put the Raspberry Pi to good use: 1. Install Mysql sudo pacman -S mysql 2. Start your server # systemctl start mysqld 3. Secure your mysql installation # /usr/bin/mysql_secure_installation ——————- NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE… Continue reading
Let's make a lamp First M for Mysql: # apt-get install mysql-server The script will ask you to define the password for the root mysql user: Secure your mysql installation: # mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION… Continue reading
# mysql -u root Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) # mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 1 Stop MySQL server: # service mysql start… Continue reading
I’ve finally decided to get started on documenting how I’ve been using this wonderful framework. So if you’re patient enough to deal with my crazy schedule (meaning this series may take a while to be finish), fasten your seatbelt: First of all: Know your environment (your public html folder, a… Continue reading
James S. Thank you for the phone call. Here is a brief summary of our conversation: You called because you were unable to access phpMyAdmin and phpPgAdmin from your AccountCenter and could not connect to the databases through a SSH client. While looking into this issue I found that the… Continue reading
Robert V. Thank you for the phone call. Here is a brief summary of our conversation: Due to the repeated inconvenience of your PostgreSQL database running out of memory intermittently since you started this account, I am reassigning this Support Request to our Billing Department to add a database container… Continue reading