Tag Archive: mysql

March 19, 2019   /   by Marco   /   , , , , ,

HOW TO FIX DELETING A TABLE THAT DOESN’T EXIST

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

January 13, 2017   /   by Marco   /   , , , , , ,

HOW TO FIX A CORRUPTED TABLE IN A MYSQL DATABASE

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

November 24, 2016   /   by Marco   /   , , , , , , , , , ,

The Complete PHP & MySQL Web Development Bundle for $29

The Complete PHP & MySQL Web Development Bundle for $29

Learn Efficiency & Data Handling Tricks to the Web Development Trade in 44 Hours
Expires November 23, 2023 23:59 PST
Buy now and get 98% off

PHP and MySQL Training

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.

Introduction to MySQL

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.

Web Application Development with CakePHP

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.

Yii PHP Framework: Web Application Development with Yii

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.

PHP & MySQL: The Ultimate Web Development Training

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.

Laravel PHP Framework Training

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.

Advanced Laravel PHP Framework Training

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.

read more

October 23, 2015   /   by Marco   /   , , , , , , , , , , , , ,

HOW TO SCHEDULE BACKUPS FOR WAMP FILES AND DATABASES

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

June 28, 2015   /   by Marco   /   , , ,

Solved: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’

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

February 23, 2015   /   by Marco   /   , , , , ,

How to disable synchronisation for a mySQL database table

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

August 30, 2014   /   by Marco   /   , , , , , ,

WAMP: Free up disk space and disable binary Logging in MySQL

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