Tag: dataabses
-
How to Backup MYSQL Databases
REM Export all databases names to file mysql -h your-server-ip -u user-name -ppassword information_schema –skip-column-names –execute=”SHOW DATABASES;” > databases.tmp echo “Start!” REM Look over database names REM Outter loop to get table names for /F %%A in (databases.tmp) do ( echo “Exporting table Names for %%A” mysql -h your-server-ip -u user-name -ppassword %%A –skip-column-names –execute=”SHOW…