OTRS 3.0.10 BACKUP DOES NOT WORK...

[qazi1214]

I FOLLOWED THE INSTRUCTIONS I WAS TOLD THAT IS STOP MYSQL SERVICE THEN COPY C:\OTRS\OTRS FOLDER THEN START THE SERVICE AND USE MYSQLDUMP TO CREATE DUMP FILE IT WORKED PERFECTLY AND CREATED A DUMP FILE OF 4 GB
THEN I UNINSTALLED THE OTRS TO TEST THE BACKUP WHICH I DID..IT WAS INSTALLED SUCCESSFULLY THEN I STOPED THE SERVICE COPIED BACK THE C:\OTRS\OTRS FOLDER THERE THEN STARTED THE SERVICE AGAIN AND USED MYSQLDUMP AGAIN TO RESTORE DATABASE FILE IT TOOK 3 OR 4 SECONDS AND IT SAID MY SQL FILE DUMPED....NOW I GO IN TO C:\Program Files\OTRS\mysql TO CHECH DATA FOLDER WHICH WAS BEFORE ABOUT 8 GB AND IT SHOULD REFLECT AFTER RESTORING IT BUT ITS NOT. ITS SHOWING ABOUT 510 MB MEANS RESTORE WAS UNSUCCESSFULL...................PLZ HELP ME OUT...I CAN LOGIN TO OTRS...BUT MY AGENTS,MY CUSTOMERS ,GROUPS,TICKETS ARE NOTTHERE ........................WHAT WRONG DID I DO IN THIS WHOLE PROCESS

[qazi1214]

i have added the contents which it shows during restoration of database through dump file..if you can have any idea

thanks

[crythias]

I don't know what the problem is. How big was your mysql dump file? did you have errors on restore?

[crythias]

This file that you attached doesn't have any data in it. I doubt you'd have been able to upload an 8gb file....

[crythias]

Why did you use mysqldump to *restore* the database? I never said to do that.

[crythias]

ok, I did say this:

How to restore:
If OTRS is already installed and you're just moving back in a point in time, restore from your backup method (ntbackup, copy back, unzip, carbonite, mozy, crashplan, backupexec, ...) then mysqldump and then empty your tables and read the someoutputfile.sql via MySQL Workbench or command line.

If OTRS isn't installed, install it at the backed up version level, then do the above things.

Read up on MySQL for more information about table maintenance, backup and restore.

AND THEN I SAID THIS:

If you need to reload the .sql dump, it's pretty much
mysql -uotrsusername -ppassword otrsdatabase < outputfile.sql

I also said to make a backup of your output file from the mysqldump.

[qazi1214]

do i need to copy c:\otrs or c:\otrs\otrs folder as application side backup ???
if you say copy the c:\otrs then i think there is no point of copying it all because it will also copy database.then why should we go for mysqldump then ????
my dump file was 4 gb file;;;the file which i uploaded is about what i have been gettin on commND PROMPT WHILE IT WAS DUMPING THE FILE BACK TO THE DATABASE...dont you think otrs database folder should increase in size once i dump the sql file in to database....in my my case it does not increase...
so would i come know after dumping that i has filled all the tables in the database after dumping by using this <.....

[kettysimpson]

It might be possible that your OTRS not configured properly or it may be because you have attached file is larger than the capacity. Yes you have to copy the directory back for the side backup.

[qazi1214]

i used mysql workbench application but the problem is when i give it the dump file created by mysqldump..it gives error message ERROR 1046 (3D000) at line 22: No database selected.....plz tell what could be the reson
then i exported the sql file through mysql workbench and then i imported that file it was done successfully
i could not find any option in mysql workbench to automate the backup process of database.....because i have to run the backup everyday scheduled......
how can i automate the mysql database backup on windows???

i know u can create a batch file which will make dump file through mysqldump....thats okay..but when i try to use this file to put it back to database ...the process freezez up....(using mysqldump)
i also tried that mysqldump file to import it in to database through mysql workbench but it ended up saying...ERROR 1046 (3D000) at line 22: No database selected...........................but if i use the dump file created by mysql workbench...that works perfect inside mysql workbench for importing..............................please help

[jojo]

you should really read the mysql admin book or get a qualified database admin!

[crythias]

In mysql workbench, you can use the left side (SQL Development) connection to the database, select the default schema (right-click, set as default), import an sql file, then execute the script. If you want, just create a new schema and test restore on it.

[ferrosti]

@quazi1214
Please get into mySQL administration. Its documentation about backup and restore is very well written and understandable.
'mysqldump' is not intended for restore purpose! Please make sure that you understand what you are doing and read at least the very basics of your programs manuals.

A broken 4GB file sounds somewhat like a dump to a FAT32 partition. Make sure your file system is capable of storing files larger than 4GB.

[qazi1214]

i was usin the wrong command to restore which is mysqldump -u root otrs < sql file so crythias help me with it and told right command which is mysql -u root otrs < sqlfilename and it worked like rocket
anyway thanks for your considerations