How import xml file from ftp

WordPress itself is what generates the export file, so you will need access to the site to do so.

If you still have access to the old hosting account, you could just move the database itself instead by backing it up and restoring it: https://codex.www.ads-software.com/Moving_WordPress#Moving_to_a_New_Server

Can i access xml file from cpanel? Ive accès to old ftp where the site was located but not not the old site anymore.

https://www.ads-software.com/plugins/woof-by-category/

As macmanx noted, to generate XML, first log in to the dashboard:

Dashboard -> Tools -> Export

If you have access to cPanel, then it’s possible you still have access to your old site through the IP address assigned to your hosting account. Check your cPanel home page for the IP address; it’s usually listed in a prominent location. Now, assuming the IP address is xxx.xxx.xxx.xxx and your cPanel username is cpuser, load the following URL into your browser:

https://xxx.xxx.xxx.xxx/~cpuser

You may get lucky and your old site will show up. It will probably be broken because the site and home URLs in the WordPress database are incorrect. The URLs can be fixed by adding a couple lines into the wp-config file, but let’s make sure you can access your old site before going any further.

Or, if you have access to cPanel, backup the database via phpMyAdmin on the old host’s cPanel, and restore it via phpMyAdmin on the new host: https://codex.www.ads-software.com/Moving_WordPress#Moving_to_a_New_Server

i just verified and still have acces to the cpanel. BUT NOT THE SITE.. Ive acces to phpadmin and database

• This reply was modified 7 years, 3 months ago by him666.

Excellent, so backup the database from the old cPanel: https://codex.www.ads-software.com/Backing_Up_Your_Database

And, restore it on the new one: https://codex.www.ads-software.com/Restoring_Your_Database_From_Backup

ok the the db.sql file is imported via phpmyadmin (it was only a 2mb file) but still not see the change, i think i forget to change the old db name for the new one when i import it so all files are there in phpmyadmin but still cannot acces old post and file via wordpress panel, where can i change my old db name to new one?

• This reply was modified 7 years, 3 months ago by him666.

Make changes to your wp-config.php file to match the new database details: https://codex.www.ads-software.com/Editing_wp-config.php#Set_Database_Name

Including the table prefix: https://codex.www.ads-software.com/Editing_wp-config.php#table_prefix

for some reason my site work, but in the dashboard i dont see the uploaded media (that ive upload via ftp) and the old post and site structure… ive upload the .sql fil into phpmyadmin all is there .
cabaretcarol.com/

• This reply was modified 7 years, 3 months ago by him666.

If wp-config.php is directed to the right database and includes the matching table prefix, you should see all of your posts and content.

If not, you may need to give someone direct access to sort this out. For that, please try https://jobs.wordpress.net/ or https://jetpack.pro/ and do not accept any hire or direct access offers posted to these forums.