XF 2.2 Restore SQL data

[Binkaddas]

Good Morning support,

kindly i need your support to know what is the best app or way to restore big SQL data ( it's 1.07GB ) as below

 

[Chromaniac]

1GB should be easily doable over CLI even on a low end server config! I wouldn't suggest doing it over browser though.

 

[Miri]

Thread 'Importing Large MySQL Databases with Putty - Step-by-Step Guide'

Jan 7, 2024

In 2016, I wrote this guide so I could remember the steps. Since I'm about to delete that page, I wanted to still keep the information in case I need it again and wanted to publish it here in case it might be useful to some of you. Now, I don't know how current this guide is (which is why I haven't published it as a resource) and I haven't tested it recently. The guide was translated using chatgpt.

DIY webmasters often face hurdles when importing large MySQL databases via Phpmyadmin due to size limitations and timeouts. This need can arise in various scenarios, such as...

• Miri
• Replies: 1
• Forum: Off topic

• 
• 

 

[Binkaddas]

1GB should be easily doable over CLI even on a low end server config! I wouldn't suggest doing it over browser though.

thank you for your kind support, what dose it mean CLI?

 

[Binkaddas]

Thread 'Importing Large MySQL Databases with Putty - Step-by-Step Guide'

Jan 7, 2024

In 2016, I wrote this guide so I could remember the steps. Since I'm about to delete that page, I wanted to still keep the information in case I need it again and wanted to publish it here in case it might be useful to some of you. Now, I don't know how current this guide is (which is why I haven't published it as a resource) and I haven't tested it recently. The guide was translated using chatgpt.

DIY webmasters often face hurdles when importing large MySQL databases via Phpmyadmin due to size limitations and timeouts. This need can arise in various scenarios, such as...

• Miri
• Replies: 1
• Forum: Off topic

• 
• 

thank you for your kind support

 

[Chromaniac]

terminal. basically ssh access to your server. 1GB SQL file is easily doable with the command mentioned in the above linked resource! if you do not have ssh access to your server, upload the file on the server and ask your host to import it for you i suppose.

 

[Binkaddas]

terminal. basically ssh access to your server. 1GB SQL file is easily doable with the command mentioned in the above linked resource! if you do not have ssh access to your server, upload the file on the server and ask your host to import it for you i suppose.

Noted, thank you