Tag Archive: mysql
SCRIPT TO BACKUP ALL MYSQL DATABASES IN VESTACP
If you have multiple databases hosted on VestaCP the easiest way I found to backup all the databases is to use a script. The first thing you need to do is create a backup account in mySQL that has view only access to all the databases. CREATE USER ‘backupuser’@’localhost’ IDENTIFIED BY ‘xxx’; GRANT SELECT, SHOW […]
read more
HOW TO FIX DELETING A TABLE THAT DOESN’T EXIST
In my mySQL database I noticed that there was a table missing from phpmyadmin. I tried creating the table but mySQL reported that it already exist (it was a ghost table). I tried using mysqlcheck to repair the database and it came back saying it the table didn’t exist. I then tried to create the table and […]
read more
HOW TO FIX A CORRUPTED TABLE IN A MYSQL DATABASE
One of the websites I manage Digital Signage Blog was not displaying correctly (posts were not displaying, menu was missing links to the categories and only displaying pages) and after some investigation, I discovered one of the database tables (the categories table – wp_term_taxonomy) was corrupted. I attempted to repair the database by using these instructions […]
read more
The Complete PHP & MySQL Web Development Bundle for $29
KEY FEATURES
PHP and MySQL are two important tools used in web development, allowing you to create interactive content that integrates with databases to manage large amounts of data. Learning both will help you create login pages, check details from a form, create forums, restrict user access to certain pages, and much more. Your websites will have considerably more functionality, and you can leverage the knowledge you gain in this course into high-paying web development jobs.
- Access 42 lectures & 8 hours of content 24/7
- Download & install PHP & MySQL tools
- Work between a user interface & a database to exchange information
- Learn advanced concepts in PHP & MySQL
- Plan & apply PHP & MySQL to your own real world projects
PRODUCT SPECS
Details & Requirements
- Length of time users can access this course: lifetime access
- Access options: web streaming, mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Compatibility
- Internet required
THE EXPERT
An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill based education addressing the needs 500,000+ members across 40+ Countries. Our unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the Industry help participants achieve their goals successfully. All our training programs are Job oriented skill based programs demanded by the Industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. Therefore we ensure that you can enroll 24 hours a day, seven days a week, 365 days a year. Learn at a time and place, and pace that is of your choice. Plan your study to suit your convenience and schedule.
For more details on this course and instructor, click here.
KEY FEATURES
MySQL is the web’s most popular open source SQL database management system, and is an invaluable asset to web developers who want to be able to track and manage data on their sites. In this course, you’ll learn how to use the MySQL Server and tools, while discovering how to incorporate it into your own websites and apps. By course’s end, you’ll have a skill that will make both your websites and your resume shine.
- Access 9 lectures & 2 hours of content 24/7
- Use MySQL to build databases, populate them w/ data & query that data
- Create a Well Structure database
- Select rows & columns from a table within MySQL
PRODUCT SPECS
Details & Requirements
- Length of time users can access this course: lifetime access
- Access options: web streaming, mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Compatibility
- Internet required
THE EXPERT
An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill based education addressing the needs 500,000+ members across 40+ Countries. Our unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the Industry help participants achieve their goals successfully. All our training programs are Job oriented skill based programs demanded by the Industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. Therefore we ensure that you can enroll 24 hours a day, seven days a week, 365 days a year. Learn at a time and place, and pace that is of your choice. Plan your study to suit your convenience and schedule.
For more details on this course and instructor, click here.
KEY FEATURES
CakePHP is an open-source, rapid web development framework that makes building web apps faster and require less code. It’s an efficiency tool that can significantly accelerate your workflow, making you a more desirable hire for tech companies.
- Access 17 lectures & 3 hours of content 24/7
- Install & configure CakePHP
- Learn database access methods, manipulate queries, & use sub-forms
- Use tools like PHPUnit & Selenium
- Upload images, incorporate themes to your web pages, debug, & log data effectively
PRODUCT SPECS
Details & Requirements
- Length of time users can access this course: lifetime access
- Access options: web streaming, mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Compatibility
- Internet required
THE EXPERT
An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill based education addressing the needs 500,000+ members across 40+ Countries. Our unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the Industry help participants achieve their goals successfully. All our training programs are Job oriented skill based programs demanded by the Industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. Therefore we ensure that you can enroll 24 hours a day, seven days a week, 365 days a year. Learn at a time and place, and pace that is of your choice. Plan your study to suit your convenience and schedule.
For more details on this course and instructor, click here.
KEY FEATURES
Yii is a high-performance PHP framework that allows you to build web app features quickly and securely. Once you’ve created a database, Yii generates the base PHP code, which you can then customize for your exact specifications. In this course, you’ll learn how to work with this framework, adding an efficiency tool to your web development arsenal.
- Access 27 lectures & 5 hours of content 24/7
- Install & configure Yii on your system
- Create a working application step-by-step
- Learn database access methods, manipulate queries, & use sub-forms
- Discover the PHP Unit & Selenium
- Upload images, incorporate themes to your web pages, debug, & log data effectively
PRODUCT SPECS
Details & Requirements
- Length of time users can access this course: lifetime access
- Access options: web streaming, mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Compatibility
- Internet required
THE EXPERT
An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill based education addressing the needs 500,000+ members across 40+ Countries. Our unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the Industry help participants achieve their goals successfully. All our training programs are Job oriented skill based programs demanded by the Industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. Therefore we ensure that you can enroll 24 hours a day, seven days a week, 365 days a year. Learn at a time and place, and pace that is of your choice. Plan your study to suit your convenience and schedule.
For more details on this course and instructor, click here.
KEY FEATURES
This massive, 20-hour course will completely immerse you in the web development tools, PHP and MySQL. You’ll learn how to perform backend coding with PHP, while using MySQL to store and input data throughout the site. By course’s end, you’ll be building seamless, interactive websites in your sleep!
- Access 110 lectures & 20 hours of content 24/7
- Write PHP scripts & understand the variables, constants, & data types in PHP
- Learn conditional statements & loops in PHP
- Understand how to handle files in PHP
- Discover PHP functions & arrays
PRODUCT SPECS
Details & Requirements
- Length of time users can access this course: lifetime access
- Access options: web streaming, mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Compatibility
- Internet required
THE EXPERT
An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill based education addressing the needs 500,000+ members across 40+ Countries. Our unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the Industry help participants achieve their goals successfully. All our training programs are Job oriented skill based programs demanded by the Industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. Therefore we ensure that you can enroll 24 hours a day, seven days a week, 365 days a year. Learn at a time and place, and pace that is of your choice. Plan your study to suit your convenience and schedule.
For more details on this course and instructor, click here.
KEY FEATURES
Laravel is an open source PHP web app framework designed for the development of MVC web applications. This efficient, simple framework is a valuable tool in building websites quickly and professionally, so you can deliver a high quality product in a timely manner. In this course, you’ll go from A to Z in Laravel, and add a valuable skill to your development repertoire.
- Access 14 lectures & 3 hours of content 24/7
- Install & configure Laravel
- Prepare a dev environment
- Learn routing & requests in Laravel
- Control databases using Laravel
PRODUCT SPECS
Details & Requirements
- Length of time users can access this course: lifetime access
- Access options: web streaming, mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Compatibility
- Internet required
THE EXPERT
An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill based education addressing the needs 500,000+ members across 40+ Countries. Our unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the Industry help participants achieve their goals successfully. All our training programs are Job oriented skill based programs demanded by the Industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. Therefore we ensure that you can enroll 24 hours a day, seven days a week, 365 days a year. Learn at a time and place, and pace that is of your choice. Plan your study to suit your convenience and schedule.
For more details on this course and instructor, click here.
KEY FEATURES
You can always write better code and learn more advanced concepts to make your websites work better, and that’s the theme of this course. You’ll dive into advanced concepts of Laravel PHP, discovering how to use this framework to its fullest potential in your site and app building.
- Access 19 lectures & 3 hours of content 24/7
- Discuss localization, sessions, forms, validations, & more in Laravel
- Integrate w/ AJAX for greater efficiency
- Understand email & error handling
- Learn how to connect, retrieve from, & insert into databases
PRODUCT SPECS
Details & Requirements
- Length of time users can access this course: lifetime access
- Access options: web streaming, mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: advanced
Compatibility
- Internet required
THE EXPERT
An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill based education addressing the needs 500,000+ members across 40+ Countries. Our unique step-by-step, online learning model along with amazing 1700+ courses prepared by top notch professionals from the Industry help participants achieve their goals successfully. All our training programs are Job oriented skill based programs demanded by the Industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. Therefore we ensure that you can enroll 24 hours a day, seven days a week, 365 days a year. Learn at a time and place, and pace that is of your choice. Plan your study to suit your convenience and schedule.
For more details on this course and instructor, click here.
HOW TO SCHEDULE BACKUPS FOR WAMP FILES AND DATABASES
I managed to figure out a way to backup the WAMP files and databases by using the Windows Task Scheduler and a batch file. The batch file includes using mysqldump (already part of the WAMP install), 7-zip (a free open source compression tool) and gzip (for the database compression). BATCH FILE Let’s have a look […]
read more
Solved: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
My VPS server experienced an issue with mySQL server and thought I’d better document how to resolve it in case it happens again. The symptoms An Error message saying unable to connect to the database comes up when trying to access websites using WordPress Manually starting the mysqld came back with “Failed”- using the command […]
read more
How to disable synchronisation for a mySQL database table
In a previous post, I wrote an article on how to setup database replication using mySQL. I recently had to figure out a way to exclude a database table in the replication process and this is what I had to do: NOTE: I’m using WAMP as my website hosting software Open up the my.ini file under […]
read more
WAMP: Free up disk space and disable binary Logging in MySQL
Our Windows VPS server was running out of disk space (had only 1GB out of 40GB) and I decided to run a scan to check which files and directories was using the most amount of space. You can use an open source tool called WinDirStat Portable to run the scan. After you run the scan, […]
read more
