Call us: +44 20 8720 6583

Contact Us: contact@podtech.com

Contact Us
Contact Us
PODTECH

MYSQL

Stay ahead with the latest trends in custom software development. Explore how AI, automation, and cloud solutions are shaping the future of business technology.
,

Oracle Adds Machine Learning Support to MySQL HeatWave

Oracle has just announced that its Oracle MySQL HeatWave now supports in-database machine learning (ML) in addition to the previously available transaction processing and analytics, to help eliminate the need to move data or the model to a machine learning tool or service. As announced, MySQL HeatWave ML fully automates the machine learning lifecycle and […]
Continue Reading

MYSQL Dump Single Table

Dumping Single MYSQL Table mysqldump db_name table_name > table_name.sql mysqldump -u -h -p db_name table_name > table_name.sql mysqldump -u -h -p db_name table_name --events --triggers --routines > table_name.sql    
Continue Reading
,

Extract Table from SQL Dump – MYSQL

Extract Table from SQL Dump – MYSQL The script below creates individual table exports from a SQL dump. ./MyDumpSplitter.sh yourfile.sql your_table_name [code] #!/bin/sh # http://kedar.nitty-witty.com #SPLIT DUMP FILE INTO INDIVIDUAL TABLE DUMPS # Text color variables txtund=$(tput sgr 0 1)    # Underline txtbld=$(tput bold)       # Bold txtred=$(tput setaf 1)    # Red txtgrn=$(tput setaf 2)    # […]
Continue Reading
,

2002 Cannot log in to the MySQL server – MAC

2002 Cannot log in to the MySQL server – MAC To fix In /etc/php.ini, replaced the three occurences of /var/mysql/mysql.sock with /tmp/mysql.sock prompt% sudo chmod u+w php.ini   <- had to give myself write permission to that file.. you may need to become root user to actually edit the file.. depends who owns php.ini Now edit […]
Continue Reading