- Save your backup.sql file in the local C:\Tix7\Output folder (this is the default).
- Bring up a command prompt (DOS) window.
- Type cd c:\Tix7\Output.
- Press Enter. Type dir and press Enter. You will get a listing of files. You should be able to figure out the latest backup file.
- Type the following command exactly as it appears below (except for the name of the SQL file, which will change according to the date it was created), including spaces:
- mysql -u root -p –database tix7 < WintixBackup_month_date_year (ie. 2012).sql
- IMPORTANT! What looks like one dash before database tix7 is actually TWO dashes!
- Hit Enter.
- The cursor will flash until the restore is done.
- When the flashing cursor comes back to the C:\Tix7\Output prompt, the restore will be done. Open Wintix and confirm that the data is current and correct.
Notes:
- A blank root password is bad security. However, this is the database default.
- When it asks for your password, press enter (the root password is blank).
- If you are working on a Linux server, the command and files names are case sensitive.
If you get a message, “not recognized as an internal or external command” that could mean:
A) You are not actually on the server.
B) The MySQL server is not in the path (set up when installing the server). Therefore, you must run the command like this:
“C:\Program Files\MySQL\MySQL server 5.5\bin\mysql -u root -p –database tix7 < {name of backup file}”
Categories
- Accounting
- American Disabilities requirements for ticketing
- Authorize.net
- Central Box Office
- Coronavirus information
- Credit Card Processing
- Datamax printer setup
- Datamax printers
- Desktop Software
- Donations
- E-commerce
- FGL printer setup
- FundRaiser Software
- General Information
- Gift cards
- GoDEX
- Internet connectivity
- Just for fun
- Newsletters
- Printers/Tickets
- Reports
- Scanning
- ScanTix
- Season package/season tickets
- Seating Plans & Charts
- Security
- Stripe
- Tickets
- Uncategorized
- Updates – Webtix
- Updates – Wintix
- Video tutorial
- Webinar
- Webtix Full License
- Webtix Online Ticketing
- Webtix Rental
- Webtix5
- Webtix6
- Wintix 6
- Wintix5
Tags
-
Recent Posts