Hi @Rakesh Kumar Srivastava,
Thank you for your inquire.
It is important to notice that there is a dependency between database and filesystem, meaning that if you have created content on Confluence, creating a database dump may not be enough, resulting in data loss (because you no longer have data stored in <confluence-home> directory. Further information can be found in Restoring Data from other Backups
For reasons above mentioned, I would kindly suggest you on reviewing Site Backup and Restore documentation for further information.
Regarding on the issue you are experiencing, would be possible for you to share the error you have mentioned - When i import all tables and data from sql file, it gives error. If you consider this as confidential information, then I would suggest you raising a Support Case with Atlassian Support so they can provide you with the assistance you need.
Kind regards,
Rafael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.