Download the PHP package delta-solutions/mysqltools without Composer

On this page you can find all versions of the php package delta-solutions/mysqltools. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Informations about the package mysqltools

mysqltools

Mysqltools

Latest Version on Packagist Downloads

Mysqltools is a versatile command-line tool designed to streamline the management of your MySQL databases. With its user-friendly interface and powerful features, this tool simplifies tasks such as comparing database structures and creating backups.

Use case

Managing database structures can be challenging, especially when you prefer creating databases in your favorite SQL tool rather than using migrations. Mysqltools solves this problem by allowing you to compare the structure of a source database with a target database. You can easily retrieve SQL statements to synchronize the structures, ensuring consistency between your development and live databases.

Requirements

Mysqltools is a command-line tool that has been extensively tested on both macOS desktops and Linux servers. Its compatibility with these platforms ensures a seamless experience, providing you with a reliable and efficient solution for your database management needs.

Installation

`

Usage

Once mysqltools is installed you can get an overview of all the commands by running the mysqltools command. You will see this welcome screen.

The welcome screen

Backup a database

command to run: mysqltools mysql:backup or mt mb

This command dumps the structure of your database to an SQL file and stores the data from the database in .csv files. The resulting files are stored in your Downloads folder. If you only want to create a backup of the structure without the data, you can add the --nodata option. If you want to create a backup of only the structure you can add the --nodata option

Compare two database structures

command to run: mysqltools mysql:compare or mt mc

This command compares the structure of two databases and outputs the differences between the source and target databases in an SQL file. The resulting file is stored in your Downloads folder.

Create an ssh tunnel from your local machine to a mysql server

command to run: mysqltools mysql:tunnel or mt mt

This command sets up an SSH tunnel from your local machine to a MySQL server. It is useful when you want to connect your application over an SSH tunnel to your database server. By using this command, you can choose a specific port (e.g., 13306) to connect to your database over SSH. You can then configure your application to connect to the local port as if it were connecting to localhost. This allows your application to reach the database server even if it's located on another location that requires an SSH tunnel.

All versions of mysqltools with dependencies

PHP Build Version
Package Version
Requires illuminate/filesystem Version ^8.61
illuminate/support Version ^8.61
symfony/console Version ^5.3
symfony/process Version ^5.3
symfony/finder Version ^5.3
nunomaduro/termwind Version ^1.15
spatie/ssh Version ^1.8
ext-json Version *
doctrine/dbal Version ^3.6
ext-openssl Version *
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package delta-solutions/mysqltools contains the following files

Loading the files please wait ....