Hi All
I have dump of mysql DB (Joomla), and I found out that there is absolute links on the DB not with the domain name but the IP address ex:
There is two IP's always in the absolute links because the website is behind a load balancer, the issue caused showing the IP address instead of the domain name in the browser URL bar.
I checked the absolute links with the IP and I found that there is four possibilities :
What's the right way to replace those links with the domain name instead ?,
those value are not commented but exist in the DB tables.
The name are the two IP servers because behind the load balancer.
I want to replace on the dump file then I will import it to DB.
thanks this is work for the two IP I posted but actually the real IP looks like this:
55.58.26.211
55.58.16.247
how I can modify the cmd to support those exact two IPs ?
Hi,
I have a dumpfile.sql -
========Start of file=================
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */;
CREATE TABLE `test_table1` (
`id` int
) AUTO_INCREMENT=12
CREATE TABLE `test_table2` (
`id` int
) AUTO_INCREMENT=120... (5 Replies)
Hi All,
I tried searching a lot about this but to no avail. I have a HTML file. I used
links -dump file_page.html > text_html.txt
What the above command gave me was a filtered text from the HTML file with tags removed. Now, the the output from the above command looked something like this:... (1 Reply)
Hi folks
I have mysql dump which having insert queries, i want to break that file when 10 complete "INSERTS" lines so extract that line and store in 1.sql and 2.sql and for next 10 insert lines.
pls guide me how can i do that.
Regards,
Bash (2 Replies)
consider a fixed length file
12345abcd8901
12345abcd7777
12345njdu8888
12345hdku8388
i would like to dump it in to oracle DB using sql loader
12345 in to first coloumn
abcd in to second coloumn
8901 in to 3rd coloumn (2 Replies)